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 “recleaning” with Change Limit: [1] [2] [3]

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

114 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
recleaning133675(None) 
precleaning1644261precleaning
cleaning113112382__cleaning
preclearing1645102preclearing
recaning111416692rec__aning
reclining121112282recl_ining
recreating131214582recreating
relearning1135282re_learning
releasing10411012re_leasing
reloaning10710482re_loaning
repleading1436622repleading
becloaking1944883becloaking
beclowning1843423beclowning
befleaing1544023beflea_ing
beleaping1436743be_leaping
bemeaning1436193be_meaning
cleansing1235073__cleansing
clearing113014883__clearing
cleating113518133__cleating
cleaving141389683__cleaving
deceasing1338403dec_easing
decerning1337293dec_erning
declaring1339573decl_aring
declawing1636213decl_awing
declining13129353decl_ining
decreasing1446513decreasing
defleaing1444743deflea_ing
deleading1237773de_leading
deleaving1436263de_leaving
demeaning1337243de_meaning
deplaning1338053depl_aning
gleaning10269323__gleaning
leaning83721203___leaning
nucleating1346933nucleating
overcleaning1844933overcleaning
precreasing1645703precreasing
preweaning1645633pre_weaning
realigning1245933realigning
reblending1455813reblending
recanting122414823rec__anting
receding122713763rec_e_ding
receiving1538993rec_eiving
recessing12611013rec_essing
rechanging1746043rec_hanging
rechecking2244463rechecking
rechewing1836493reche_wing
reckoning1637643rec_koning
recladding1543973recladding
reclaiming1546583reclaiming
reclasping15105083reclasping
reclean938523reclea__n_
recleaned1236583reclean_ed
recleans1037513reclea__ns
reclothing1644973reclothing
recoaling121312453rec_oaling
recoating121317463rec_oating
recoining121313803rec_oining
reconning121410793rec_onning
recrating121318793rec_rating
recrowning1645213recrowning
reddening1237433redde_ning
redlining111210293redl_ining
redreaming1446443redreaming
reearning1039053re__earning
reelecting1338783reelecting
reelevating1544963reelevating
reflating132514713refl_ating
reflecting1638823reflecting
reflexing2035933refle_xing
refloating14198323refloating
regearing112211413re_gearing
regelating1239953regelating
reglazing2046553regl_azing
regreening1246033regreening
rehearing132211763re_hearing
reheating132314913re_heating
relacing112516043re_l_acing
relanding112110923re_l_anding
relating92725443re_l_ating
relaxing162612633re_l_axing
relaying122515153re_l_aying
relegating1239483re_legating
relending112412023re_lending
relenting102716773re_lenting
reletting102713943re_letting
relining93218743re_l_ining
reloading1189883re_loading
reopening1248823reope_ning
repealing122513543re_pealing
repeating122618983re_peating
replacing142210163repl_acing
replanning1345313replanning
replanting1338523repl_anting
replating122217403repl_ating
replaying15259603repl_aying
repledging1543623repledging
replevining1743153replevining
replevying1953273replevying
rereading111212713re_reading
rereleasing1243983rereleasing
rescreening1444083rescreening
resealing102115673re_sealing
reseating102421533re_seating
reslating102516993resl_ating
respeaking1736803respeaking
reteaming122110443re_teaming
retearing102214253re_tearing
retreading12128483retreading
retreating111414773retreating
revealing132611883re_vealing
rewearing132310703re_wearing
reweaving16227073re_weaving
richening1546223riche_ning
secerning1246203sec_erning

Search took 8 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 Filter1786911406030.186960704.3
2DLD Change Limit1406031146.87320457.3
3Display Results1141140.0502280.0
 (SQL Overall)1786911147.10925135.9
 
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.