Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “preconceptions” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
preconceptions225388(None) 
preconception2154281preconception_
reconceptions1965121_reconceptions
reconception1855642_reconception_
conceptions17410593___conceptions
misconceptions2263573misconceptions
preconcerting2084413preconcerti_ng
preconditions1854893precon_ditions
preconvention2074003preconvention_
preconvictions2353353preconvictions
reconnections1765753_reconnections
conception16410454___conception_
decongestions1753564_decongestions
misconception2163994misconception_
perceptions1798194p_e__rceptions
postconception2282454postconception_
precognitions1853594preco_gnitions
precombustions2262054precombustions
preconceives2152794preconce__ives
preconceiving23102364preconceivi_ng
preconcerts17154504preconcert___s
precondition1755244precon_dition_
preconviction2253704preconviction_
premonitions1646854premon__itions
preoccupations2252014pre_occupations
preoptions1447644pre_o___ptions
preponderations20112874preponderations
receptions1449744_re___ceptions
recollections1754724_recollections
reconditions1546824_recon_ditions
reconnection1655994_reconnection_
reconversions1853864_reconversions
reconvictions2054874_reconvictions
apperceptions1893035appe__rceptions
brecciations1844285brec__ciations
chemoreceptions2671785chemoreceptions
conceptional1856915___conceptional
concertinos15158125___concertinos
concessions15128105___concessions
concoctions1448255___concoctions
concretions1549295___concretions
confections18411395___confections
congestions1449315___congestions
connections15410705___connections
conniptions1546035___conniptions
contentions13412095___contentions
convections18411495___convections
conventions16410535___conventions
deceptions1547865_de___ceptions
decoctions1547145_deco_c__tions
deconditions1645285_decon_ditions
decongestion1653925_decongestion_
disconnections1954025disconnections
exceptions2146865__e__xceptions
inceptions1448535____inceptions
misconnections2063815misconnections
nonconnections1894145nonconnections
perception1688615p_e__rception_
percolations1648055perco__lations
personations1448395person__ations
photoreceptions2473355photoreceptions
precanceling1952775precance_li_ng
precancellation2161165precancellation_
precancelling2051745precancelli_ng
precancerous1851965precance__rous
precautions1546555pre___cautions
preceptors1657055pre___cept_ors
precessions1548555pre___cessions
precipitations2085395precipitations
precocious1644745preco_c___ious
precocities1748165preco_c_iti_es
precognition1753885preco_gnition_
precombustion2162245precombustion_
preconceive2053355preconce__i_ve
preconceived2252475preconce__ived
preconcert16147975preconcert____
preconcerted1953865preconcert__ed
preconditioned2062415precon_ditioned
preconscious1852905precon__scious
predications17411185pre_dic_ations
predictions1649655pre_dic__tions
predigestions1773285pre_digestions
predilections1853565pre_dilections
predominations19105545predominations
preemptions17134855pre___emptions
preformations2045715prefo_rmations
preignitions1554005preign__itions
prelections151210475pre___lections
premonition1547355premon__ition_
premunitions1644985premun__itions
prenominations18105765prenominations
prenotions1248295pre__n__otions
preoccupation2152395pre_occupation_
preoption1348085pre_o___ption_
preponderation19103225preponderation_
preportions1548265prepo___rtions
prepositions16108305prepo__sitions
prepossessions1762295prepossessions
prescriptions19135335pre_scriptions
preselections17144445pre_selections
presentations1548135presen_tations
presumptions18153885pre__sumptions
preventions1648535pre___ventions
proactions1449345pr__oac__tions
processions1548155pr__o_cessions
procreations1647275pr__ocreations
projections2258475pr__o_jections
prolongations1673355prolon_gations
pronations12314035pr__on__ations
pronunciations18122785pronunciations
proprioceptions2091805proprioceptions
proscriptions19114165pr__oscriptions
prosecutions1645615pr__osecutions
protections15510705pr__o_tections
protonations1449075proton__ations
provocations1956875provo_c_ations
recantations1448875_recan_tations
reception13410325_re___ception_
recognitions1544855_reco_gnitions
recollection1654855_recollection_
reconceives1864265_reconce__ives
reconceiving2093455_reconceivi_ng
reconciliations1953745_reconciliations
recondition1447125_recon_dition_
reconnecting1745355_reconnecti_ng
reconsecrations1995105_reconsecrations
reconversion1754025_reconversion_
reconverting1876405_reconverti_ng
reconviction1955085_reconviction_
recordations1548645_reco_rdations
recreations13412255_rec__reations
reinfections1745325_re_infections
reinjections2144405_re_injections
reinsertions1245275_re_insertions
reinventions1554215_re_inventions
relocations13311145_relo_c_ations
renunciations1554855_renunciations
reoccupations1972765_re_occupations
resorptions1347235_reso__rptions
revocations16410315_revo_c_ations

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691950240.373479064.3
2DLD Change Limit950241406.15615436.0
3Display Results1401400.0961458.3
 (SQL Overall)1786911406.62526972.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.