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

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

128 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
react7463433(None) 
preact103220391preact
reach105123881reach
reacts83616601reacts
redact9419041redact
abreact11310822abreact
act59557842__act
beach124623892beach
beast76338642beast
beat66168302bea_t
beaut75135212beaut
bract96332722bract
breach134213722breach
breast8319632breast
coact96130572coact
dealt65234282dealt
dreamt94615712dreamt
each95530582_each
east46659102_east
eat36989052_ea_t
enact73525362enact
epact94921532epact
erect74129332erect
eruct74022352eruct
exact143516932exact
fact97142542_fact
feast85932722feast
feat76458222fea_t
great66034242grea_t
heart85440742heart
heat77061422hea_t
leach105422522leach
leant56737782leant
leapt75027472leapt
least56134882least
meant76537202meant
meat66359602mea_t
neat46356782nea_t
pact86648722_pact
peace95026082peace
peach125422492peach
peart76440752peart
peat65967932pea_t
preach133613922preach
preacts113211362preacts
race66746262r_ace
rack106234882r_ack
racy95825682r_acy
raft76245912r_aft
rant45864672r_ant
rapt67245312r_apt
rat37892742r_a_t
reacted103015712reacted
reactor93011652reactor
read55942532rea_d
readd74617132readd
reads64835272reads
ready94821502ready
real45750292rea_l
realm75621622realm
reals55038652reals
realty92713692realty
ream65841612rea_m
reams75729622reams
reap65934742rea_p
reaps75626192reaps
rear45644552rea_r
rearm75923562rearm
rears54739652rears
reata54225392reata
reave84528022reave
rebait8320402rebait
rebut75927382rebut
rec55645462re_c_
recant83228682recant
recap95718022recap
recast83422772recast
recce9514562recce
recit75235102recit
reck106130562re_ck
recs65734182re_cs
recta74220262re_cta
recti73619622re_cti
recto74520802re_cto
recut74729242recut
redacts10510942redacts
reenact9413002reenact
reest54938092reest
reface113616352reface
refect114319332refect
refit84230062refit
refract121311602refract
reft75141272re_ft
reject154116282reject
relace83122152relace
relet54749822relet
relict83623902relict
relit55340682relit
reluct83916112reluct
remet74843722remet
remit75737222remit
rent46661242re_nt
repack142412162repack
repast83520632repast
repot75132622repot
rerack122513162rerack
resat55139682resat
resect84424702resect
reset55051862reset
resit54241042resit
rest46459842re_st
ret35982832re__t
retack122612822retack
retch104818302retch
retract91318112retract
revet84938842revet
rewet85135152rewet
riant55833152riant
roach105717002roach
roast56230142roast
seat47575562sea_t
sect67443622se_ct
tact67349032_tact
teach105221122teach
teat45963632tea_t
tract75635712tract
treat56240352trea_t
yeast85327942yeast

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001281.76330516.2
3Display Results1281280.0333878.8
 (SQL Overall)1786911281.88994595.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.