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

127 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
recruit93977(None) 
recruits1036561recruits
becrust1137982becrust
recit75235102rec__it
recount9315172recount
recruited1236452recruited
recruiter1144872recruiter
recut74729242rec_u_t
acquit17610323_acquit
becrusts1244843becrusts
becurst1147853becurst
bruit76126723__bruit
circuit1148833circuit
crit65743713__cr_it
cruet74831843__cruet
crust75827663__crust
deceit93018213dec_eit
decrepit1345873decrepit
decrypt1545703decrypt
deorbit1048173deorbit
ecru65819533_ecru__
ecrus75113863_ecru_s
encrust947873encrust
eruct74022353_e_ruct
erupt74220063_e_rupt
floruit1047293floruit
fruit85122223__fruit
hermit11519443he_rmit
incrust949203incrust
jesuit1339583je_suit
merit7339183me_r_it
mesquit18387953mesquit
mezquit27365113mezquit
permit10321683pe_rmit
piecrust1244633piecrust
precut102016533prec_u_t
racquet1838743racquet
readmit1039823readmit
rebait8320403re_bait
rebuilt939973re_built
rebut75927383re_bu_t
recant83228683rec_ant
recarpet12310603recarpet
recast83422773rec_ast
receipt1159253receipt
recent83630853rec_ent
recept103319073rec_ept
rechart12314333rechart
recheat12415933recheat
recite83625113rec__ite
recits83621353rec__its
reclaim1137753reclaim
recluse95210773recluse
recoat84024273rec_oat
recoil84016723rec_oil
recoin84320293rec_oin
recommit1445553recommit
recordist1246923recordist
recounts1038773recounts
recoup10810373recou_p
recoupe11109933recoupe
recoups1188843recoups
recrate92621663recrate
recreant10311283recreant
recreate10313603recreate
recross989833recross
recrown12257573recrown
recruiters1243713recruiters
recruiting1347903recruiting
recti73619623rec_ti_
rectrix1645363rectrix
rectum103411283rectu_m
rectums11338523rectums
rectus83314633rectu_s
recur74116843rec_u_r
recurs83315803rec_urs
recurve1237403recurve
recuse85519163rec_use
recuts83817373rec_uts
redbait1039803redbait
redoubt10167843redoubt
redout71820253redou_t
redraft11310573redraft
redroot8312903redroot
reedit7617223re_edit
reemit8717223re_emit
reequip1842423reequip
reerect92915883reerect
refit84230063re__fit
refract121311603refract
refrain10310043refrain
refront10313263refront
regraft11310153regraft
regrant8317323regrant
regreet83015953regreet
regret73723533regr_et
reknit10312533re_knit
relit55340683re__lit
reluct83916113re_luct
remit75737223re__mit
remount9512283remount
reposit9315863reposit
reprint9318983reprint
requin15310713re_quin
requite162012483re_quite
rerent63832453re_rent
rerig64018483re_r_ig
rerun58722153re_ru_n
reruns66413743re_runs
rescript1277423rescript
resit54241043re__sit
resplit9310373resplit
result6318223re_sult
retract91318113retract
retrain7615423retrain
retreat7317533retreat
retrim83514883retr_im
retrofit1148303retrofit
revisit10311373revisit
revuist1038473re_vuist
rewrapt12138113rewrapt
rewrite10311143rewr_ite
schuit1139563_schuit
secret8325063secr_et
security1346693security
territ63421373te_rrit
wetsuit1045453wetsuit

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271277.01619103.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.46823927.6
 
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.