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

233 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
reknots113678(None) 
beknots1335081beknots
reknits1137071reknits
reknot10311731reknot_
beknot1239762beknot_
knots95614722__knots
reboots93512092reboots
reknit10312532reknit_
rennets75212632rennets
rents55935182re_n_ts
replots93412632replots
repots85621002re_pots
respots92912762respots
unknots1144302unknots
arenous7314183are_nous
beanos85516513beano_s
bennets94712163bennets
bentos86218303be_ntos
bents76033693be_n_ts
besnows1245153besnows
besots86415453be_sots
bowknots1743063bowknots
brents84717273bre_n_ts
cenote83715843ce_note
cenotes92814543ce_notes
centos85920463ce_ntos
cents74730333ce_n_ts
dekkos1034103dekko_s
denote74118043de_note
denotes83817003de_notes
dents65031803de_n_ts
depots94716343de_pots
despots10319683despots
enols54718403_e_nols
enows85115493_e_nows
ergots74512373_ergots
escots84211743_escots
feints94813873fein_ts
foreknows1942453foreknows
gemots93712153ge_mots
genets75716663ge_nets
genoas74013623ge_noas
genoms94412483ge_noms
gents65729613ge_n_ts
heinous1038853heinous
helots95217703he_lots
hents87330743he_n_ts
heriots10312063heriots
inkpots1335173inkpots
jennets14517633jennets
kenos95220623ke_no_s
keynote1443903keynote
keynotes1543633keynotes
knits93914743__knits
knobs11519713__knobs
knops115911813__knops
knot85630503__knot_
knouts10438313__knouts
knows124912413__knows
lenos56024863le_no_s
lentos65317403le_ntos
merlots92710123merlots
nektons1136393nektons
peanuts936993peanuts
pekoes124410423pek_oes
pennons939713pennons
pernods1038483pernods
pinots85920273_pinots
rainouts846913rainouts
rants55935343r_an_ts
reacts83616603re_acts
readopts1146493readopts
readouts938903readouts
reallots837993reallots
reanoints945363reanoints
reasons72514943reasons
reavows1335273reavows
rebaits9312573rebaits
rebatos92913113rebatos
rebooks134010513rebooks
reboot84119333reboot_
rebops10311433re_bops
rebuts84015193re_buts
recants93217093recants
recasts93413533recasts
recepts113010263recepts
recits83621353re_cits
reckons13269653reckons
recoats92616643recoats
recons84922993re_cons
recooks134711233recooks
recross989843recross
rectors93520523rectors
rectos85718783recto_s
recuts83817373re_cuts
redacts10510943redacts
redcoats1147123redcoats
redness82012443redness
redoes74623773re_does
redons75222183re_dons
redos65126763re_do_s
redouts81411663redouts
redroots937753redroots
redtops1037373redtops
reedits8511743reedits
reemits9611303reemits
reenacts1036993reenacts
reendows12234683reendows
reenjoys1842723reenjoys
reests64618893re_ests
refects124012743refects
refits94017653re_fits
reflets103513153reflets
refloats1156913refloats
reflows13258983reflows
refronts1137773refronts
regents83416543regents
regions83613473regions
reglets83512983reglets
regloss8218023regloss
reglows11288843reglows
regrets83212923regrets
regrows11269153regrows
reheats104513523reheats
reinks105012153rein_ks
reins56234563rein__s
rejects163910693rejects
rekeys13347693rek_eys
reknotted1443523reknotted
relents74018503relents
relets64025673re_lets
relicts94414593relicts
relists73817053relists
relooks114010723relooks
relucts9369673relucts
remeets93712413remeets
remelts93511493remelts
remints95117293remints
remits85622943re_mits
remnants1036843remnants
remote84222603re_mote
remotes94521613re_motes
rends65129953re_n_ds
renest64529713re_nest
renests74014213renests
renews93811753re_news
renigs74314593re_nigs
renins64526453re_nins
rennet64624853rennet_
rennins74013413rennins
renown9369983re_nown
renowns10277833re_nowns
rent46661243re_n_t_
rente54733783re_n_te
rentes65431193re_ntes
renvois1036503renvois
repasts93611933repasts
repeats94316053repeats
repents93717623repents
replot83818593replot_
replows12329703replows
reports94916213reports
repos74725793re_po_s
repot75132623re_pot_
repros84216003repro_s
rerents73319423rerents
reroofs1037943reroofs
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613re_sets
reshoes102316033reshoes
reshoots11228413reshoots
reshot93519633reshot_
reshows132510453reshows
resifts10378703resifts
resinous838503resinous
resists74414923resists
resits64725563re_sits
resods74116303re_sods
resorts74817193resorts
resows93915353re_sows
respot83117633respot_
rests54935873re__sts
results739833results
retests73813853retests
retinols8419743retinols
retints74717013retints
retools73411023retools
retorts76016513retorts
retros63820193retro_s
rets45352563re___ts
reunions837273reunions
reunite7312713reunite
reunites8312473reunites
reverts104715043reverts
revests104413733revests
revets94022173re_vets
revolts1038893revolts
revote94917453re_vote
revotes104716393re_votes
rewets94617213re_wets
rewrote1039123rewrote
rezones163213943rezones
rhinos94411123rhino_s
riots54922013r__iots
robots8313153r_obots
roots55933673r__oots
rots46454093r___ots
ruinous739763ruinous
runouts737353r_unouts
runts55927633r_un_ts
ryots85313783r__yots
segnos73610443segno_s
sennets73712583sennets
sennits73811283sennits
senors63620793se_nors
sexpots1636293sexpots
snots55225123__snots
teapots939053teapots
telnets738373telnets
tenets65518953te_nets
tenons62916603te_nons
tenors63217753te_nors
tents56434213te_n_ts
topknots1443303topknots
unknits1135553unknits
unknot1037413unknot_
venoms114211213ve_noms
venous93713193ve_nous
vents86125933ve_n_ts
xenons132710483xe_nons
zealots1636763zealots

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 Limit1340272336.86019537.5
3Display Results2332330.0763065.8
 (SQL Overall)1786912337.32624391.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.