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

103 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
reclasps123505(None) 
beclasps1444351beclasps
reclasp1136641reclasp_
beclasp1335262beclasp_
clasps104512092__clasps
declass1038732declas_s
enclasps1245132enclasps
inclasps1244352inclasps
recaps103615732rec_a_ps
recasts93413532rec_asts
reclads1049992recla_ds
reclaims1236112reclaims
reclames12310892reclames
reclasped1444862reclasped
recluses105111732recluses
tieclasps1342212tieclasps
unclasps1244572unclasps
becaps123811403bec_a_ps
beclasped1643743beclasped
bedlamps1543663bedlamps
clamps124515083__clamps
claps95626183__cla_ps
clasp95517193__clasp_
claspt104513413__claspt
class75525483__clas_s
clasts84817293__clasts
cyclases1537133cyclases
decamps1435643dec_amps
deceases11410153deceases
declaims1345823declaims
declares11611313declares
declasse1165943declasse
declasses1246443declasses
declaws1336253decla_ws
dewlaps1334663dewla_ps
eclairs935963_eclairs
eclats8313033_ecla_ts
ectases92911673_ectases
ectasis9249613_ectasis
enclasp1145843enclasp_
euclases1039223euclases
gelcaps1235203gelca_ps
inclasp1145303inclasp_
pectases122411193pectases
precasts1239453prec_asts
rasps74316663r___asps
realises82420183realises
realisms102212163realisms
realists83014843realists
reaps75626193re__a_ps
recalls92613623rec_alls
recanes93222263rec_anes
recants93217093rec_ants
recap95718023rec_a_p_
recast83422773rec_as_t
recess8314263rec_es_s
recesses10312323recesses
recharts1337663recharts
reckless14257973reckles_s
reclad9311873recla__d
reclaim1137753recla_im
reclame11411063recla_me
reclasping15105083reclasping
recleans1037513recleans
reclines103718543reclines
recluse95210773reclus_e
recoals94214623recoa_ls
recoats92616643recoa_ts
recoups1188843rec_oups
recrates102420373recrates
recross989833recros_s
recusals1056393recusals
recuses94619463rec_uses
redcaps1247073redca_ps
reflags1156953refla_gs
reflates113115663reflates
reglazes1846793reglazes
regloss8218023reglos_s
relaces93420883re_laces
relands85214883re_lands
relapse947703re_lapse
relapses1038033re_lapses
relates73731433re_lates
relaxes143215323re_laxes
relays94316753re_la_ys
releases8313343releases
relists73817053re_lists
remaps105012873re_ma_ps
rennases848983rennases
repass84114703re_pas_s
repasts93611933re_pasts
replaces123114123replaces
replans92814943repla_ns
replants102811243replants
replates102919273replates
replays12399763repla_ys
reslates83619503reslates
restamps1234703restamps
revamps1433993re_vamps
rewraps12136563rewra_ps
tieclasp1242803tieclasp_
unclamps1443693unclamps
unclasp1135963unclasp_

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621037.20320291.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.65523343.0
 
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.