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

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
reclasp113664(None) 
beclasp1335261beclasp
reclasps1235051reclasps
beclasps1444352beclasps
clasp95517192__clasp
declass1038732declass
enclasp1145842enclasp
inclasp1145302inclasp
recap95718022rec_a_p
recaps103615732rec_aps
recast83422772rec_ast
reclad9311872recla_d
reclads1049992reclads
reclaim1137752reclaim
reclame11411062reclame
reclasped1444862reclasped
recluse95210772recluse
tieclasp1242802tieclasp
unclasp1135962unclasp
arecas84817443arec_as_
areolas71013863areolas_
becap114315053bec_a_p
becaps123811403bec_aps
beclasped1643743beclasped
bedlamp1464513bedlamp
clamp115517653__clamp
clap86429043__cla_p
claps95626183__claps
clash106219033__clash
clasps104512093__clasps
claspt104513413__claspt
class75525483__class
clast76030583__clast
cyclase1436613cyclase
decals93717713decals_
decamp1338453dec_amp
decease1049523decease
declaim1247363declaim
declare10411223declare
declasse1165943declasse
declaw1266703decla_w
declaws1336253declaws
dewlap1264843dewla_p
dewlaps1334663dewlaps
eclair836813_eclair
eclat7523603_ecla_t
eclats8313033_eclats
enclasps1245133enclasps
euclase938933euclase
fellas95116963fellas_
gelcap1136213gelca_p
gelcaps1235203gelcaps
inclasps1244353inclasps
meccas1239493meccas_
pectase112410363pectase
precast11314853prec_ast
precrash1544823precrash
rasp66029163r___asp
reales64934123reales_
realest73322433realest
realise73021813realise
realism93115923realism
realist73225383realist
realms84913493realms_
reals55038653real_s_
reap65934743re__a_p
reaps75626193re__aps
reatas64021013reatas_
recall83815723rec_all
recalls92613623recalls
recane83022873rec_ane
recant83228683rec_ant
recasts93413533rec_asts
recces10614913recces_
recess8314263rec_ess
rechart12314323rechart
rechose121312043rechose
recits83621353recits_
reckless14257973reckless
recks115625133rec_ks_
reclaims1236113reclaims
reclames12310893reclames
reclasping15105083reclasping
reclean938523reclean
recleans1037513recleans
recline94020493recline
recluses105111733recluses
recoal84117973recoa_l
recoals94214623recoals
recoat84024273recoa_t
recoats92616643recoats
recons84922993recons_
recoup10810373rec_oup
recoups1188843recoups
recrate92621663recrate
recross989833recross
recs65734183rec__s_
recta74220263recta__
rectal84418133recta_l
rectos85718783rectos_
rectus83314633rectus_
recurs83315803recurs_
recusal968673recusal
recuse85519163rec_use
recuts83817373recuts_
redcap1158493redca_p
redcaps1247073redcaps
redias74523603redias_
reels55333263reel_s_
reflag1098083refla_g
reflags1156953reflags
reflate103516263reflate
reglaze1747223reglaze
regloss8218023regloss
rehash1237433re_hash
relace83122153re_lace
relaid75518443re_laid
reland75920433re_land
relapse947703re_lapse
relate64033633re_late
relax124817803re_la_x
relay84424673re_la_y
relays94316753re_lays
release7312763release
relish93916953re_lish
relist64628413re_list
remap95418103re_ma_p
remaps105012873re_maps
rennase738713rennase
repass84114703re_pass
repast83520633re_past
replace113214283replace
replan83215823repla_n
replans92814943replans
replant93318533replant
replate93420053replate
replay113412923repla_y
replays12399763replays
reslate73520593reslate
restamp1146483restamp
revamp1336013re_vamp
rewash1237673re_wash
rewrap11127533rewra_p
rewraps12136563rewraps
teslas64212173teslas_
tieclasps1342213tieclasps
unclamp1344993unclamp
unclasps1244573unclasps

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.390458182.1
2DLD Change Limit1340271486.61020276.4
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.06025310.3
 
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.