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 “precancelling” 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.

148 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
precancelling205174(None) 
precanceling1952771precance_ling
cancelling1547213___cancelling
precancelled1951593precancell_ed
preconceiving23102363preconceiving
preconcerting2084413preconcerting
rechannelling1951423_rechannelling
repanelling1443473_repan_elling
canceling14310164___cance_ling
crenelling1345684cre__n_elling
panelling1239074p___an_elling
parcelling1546174p___arcelling
pencilling1545474p_e__ncilling
precancel1546204precance_l___
precanceled1852454precance_l_ed
precancellation2161164precancellation
precancels1644064precance_l__s
prechilling1943744prec__hilling
prehandling1853424prehan__dling
preselling1338694pre___selling
pretelling1338134pre___telling
princeling1544654pr__ince_ling
recalling122211904_reca___lling
rechanneling1852454_rechanne_ling
reconceiving2093454_reconceiving
reconciling1645484_reconc_iling
relabelling1442664_rela_belling
repaneling1345734_repan_e_ling
spancelling1643344__spancelling
becudgelling195835_becudgelling
canalling1239555___can_alling
catcalling1545125___catcalling
chandelling1844455__chandelling
channelling1743995__channelling
concealing1549305___concealing
creneling1247735cre__n_e_ling
detasselling1451705_detasselling
empanelling1662415_empan_elling
enamelling1344315__ena_melling
excelling1935645__e__xcelling
flannelling1542835__flannelling
gravelling1565215gr__a_velling
hanselling1445625___hanselling
impanelling1652625_impan_elling
kennelling1573865_ke__nnelling
kernelling1584145_ke_rn_elling
marcelling1545595___marcelling
mischannelling2271045mischannelling
paneling111013625p___an_e_ling
panellings1344535p___an_ellings
parallelling1571995p_arallelling
parceling1438445p___arce_ling
pedalling1346665p_eda___lling
penancing1436345p_enanc___ing
penciling1437415p_e__nc_iling
pencillings1652405p_e__ncillings
prancing132612165pr__anc___ing
preaccusing1843165pre_a_ccusing
preaching172811165pre_a_c__hing
preacting142412535pre_a_c__ting
prealtering1446175pre_alte_ring
preapplying1842195pre_a_pplying
preaverring1743245pre_a_verring
prebilling1595415pre___billing
precalculi1651765precalc_uli__
precancer1547095precance____r
precancerous1851965precance_rous
precancers1645255precance___rs
precasting15169835preca___sting
preceding15129365pre___ce_ding
precensoring1753225precen_soring
precenting151012155pre___centing
precessing1598745pre___cessing
prechecking2543075prec__hecking
precleaning1644265prec__leaning
preclearing1645105prec__learing
preconceive2053355preconce__ive
preconception2154285preconception
preconceptions2253885preconceptions
preconciliar1862145preconc_iliar
preconizing2548235precon__izing
precooling1545965pre___cooling
precreasing1645705prec__reasing
predeceasing18103065pre_deceasing
predrilling1543675pre__drilling
preenacting16125375preenac__ting
prefacing17118745prefa_c___ing
prehardening1952585preharde_ning
preinserting1544175pre_inserting
prelaunching2051505prelaunc__hing
premarketing2152565premarke_ting
prepackaging2451505prepa_ckaging
prepacking2145775prepa_c__king
preprocessing2053555preprocessing
prepunching2142565prepunc__hing
presentencing1852505presentencing
presignalling1761115presignalling
prevailing1656725preva___iling
prevaluing1644275preva___luing
princelings1642575pr__ince_lings
propelling1556935pr___opelling
protocolling1753025pr_otocolling
rappelling1544365_r__appelling
ravelling13269245_r__a_velling
reacceding1644225_re_acce_ding
reaccenting1665015_re_accenting
reaccepting1863895_re_accepting
reannexing1843155_re_anne_xing
reascending1544275_re_ascending
rebelling122111165_re___belling
recalculating1853645_recalculating
recanalizing2446805_recanalizing
recaning111416695_recan____ing
recanting122414825_recan___ting
recarpeting1674365_recarpe_ting
recircling1543575_recirc__ling
recondensing1653695_recondensing
reconferring1853725_reconferring
reconnecting1745355_reconnecting
reconsoling1444485_recon_soling
reconsulting1554215_reconsulting
reconvening1746295_reconve_ning
reconverting1876405_reconverting
reconveying2044635_reconve_ying
recycling1734905_rec_yc__ling
reenrolling1242705_re_enrolling
reexpelling2142525_re_expelling
refalling132010425_refa___lling
refelling132211315_re___felling
refuelling1474975_re__fuelling
rehandling1544455_rehan__dling
relabeling1344195_rela_be_ling
remodelling1542785_re_modelling
repelling122312755_re___pelling
reselling102213835_re___selling
respelling1347975_re__spelling
retackling1744435_reta_c_kling
retelling102112495_re___telling
revelling132412555_re___velling
scandalling1543445__scandalling
spanceling1543945__spance_ling
stencilling1443235ste__ncilling
teaselling1145335_te_a_selling
teazelling2043805_te_a_zelling
tramelling1346375tr__a_melling
trammelling1642615tr__ammelling
travelling1456535tr__a_velling
weaselling1454235_we_a_selling

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901488.54614602.2
3Display Results1481480.0761947.4
 (SQL Overall)1786911489.01219828.1
 
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.