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

166 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
refracts1313738(None) 
refract121311601refract_
retracts101111311retracts
detracts11138832detracts
infracts1346622infracts
reacts83616602re__acts
redacts10510942re_dacts
redrafts1235602redrafts
reenacts1036992reenacts
reerects10319922reerects
refaces123216742ref_aces
refects124012742ref_ects
reflects13288872reflects
refracted1557392refracted
refractor14156322refractor
refractors15156272refractors
refrains1139592refrains
reframes1338992reframes
refronts1137772refronts
regrafts1235302regrafts
regrants9310012regrants
reracks132310532re_racks
retraces101417272retraces
retracks14149102retracks
retract91318112retract_
retroacts1146282retroacts
artefacts1443153artef_acts
attracts1047793attracts
bearcats1267023bearcats
befrets1237613befr_ets
bracts105617773__bracts
defaces133213403def_aces
defats105114553def_a_ts
defeats113511233defea_ts
defects134511523def_ects
deflects14336733deflects
defrags1236193defra_gs
defrauds1343243defrauds
defrays1436113defra_ys
defrocks1844113defrocks
defrosts1244833defrosts
derats74625063de_ra_ts
detract101414633detract_
diffracts1843233diffracts
effaces15277273_effaces
effects1535283_effects
enacts84012973_e_nacts
epacts105010393_e_pacts
erects84116183_e_rects
errants7410643_errants
eructs83610793_e_ructs
exacts15359613_e_xacts
extracts1747623extracts
facts107021893__f_acts
fracas11311993__fracas
fracti1139963__fracti
fractus12146593__fractus
frats86829673__fra_ts
infarcts1345233infarcts
infract12610003infract_
overacts1339653overacts
perfects15107353perfects
preacts113211363pre__acts
preenacts1345843preenacts
preerects1345413preerects
prefaces15311063pref_aces
prefects1598133pref_ects
prefranks1862993prefranks
protracts1347023protracts
react74634333re__act_
readapts1145583readapts
rebaits9312573re_baits
recants93217093re_cants
recasts93413533re_casts
recharts1337663recharts
recoats92616643recoa_ts
recrate92621663recra_te
recrates102420373recrates
recreants1146623recreants
recruits1036563recruits
redact9419043re_dact_
redbaits1135903redbaits
redirects12125103redirects
redraft11310573redraft_
redraws11218473redra_ws
redroots937753redroots
reejects17336083reejects
reelects103110883reelects
reenact9413013reenact_
reerect92915883reerect_
reface113616353ref_ac_e
refaced133713573ref_aced
refalls103312243ref_alls
refect114319333ref_ect_
refences13311853refences
referents12259643referents
refights1555883refights
refits94017653ref__its
reflags1156953refla_gs
reflate103516263refla_te
reflates113115663reflates
reflect123913713reflect_
reflets103513153ref_lets
refloats1156913refloats
refocus1236973ref_ocus
reforests1245533reforests
reformats1445713reformats
refractile1544143refractile
refracting1638733refracting
refraction15137903refraction
refractions16127723refractions
refractive1846693refractive
refractory18134773refractory
refrain10310043refra_in
reframe1239393refra_me
reframed1437853reframed
refries104419733refr_ies
refront10313263refront_
regrades103212173regrades
regraft11310153regraft_
regrant8317323regrant_
regrate82618663regra_te
regrates92618403regrates
regreets9287853regreets
regrets83212923regr_ets
reheats104513523rehea_ts
rejects163910693re_jects
relaces93420883re_laces
relicts94414593re_licts
relucts9369673re_lucts
remnants1036843remnants
repacks15269543re_packs
repasts93611933re_pasts
repeats94316053repea_ts
replaces123114123replaces
replants102811243replants
reprices122913353reprices
reprints1039903reprints
rerack122513163re_rac_k
rerents73319423re_rents
reseats74319583resea_ts
resects94115593re_sects
respaces12311043respaces
respects1247703respects
restacks1438093restacks
restarts8310873restarts
restricts1138823restricts
retacks132210713re_tacks
retirants947323retirants
retrace91417343retrac_e
retraced111413033retraced
retracer101411883retracer
retracers11149553retracers
retrack131310723retrac_k
retracted12410953retracted
retractor11218513retractor
retractors12158583retractors
retrains8314533retrains
retreats8311413retreats
retroact10410003retroact_
rewraps12136563rewra_ps
rewrapt12138113rewrapt_
ricracs1136363ricrac_s
seracs84418573se_rac_s
terraces102712253terraces
tracts85019073__tracts

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 Limit1461621667.36019859.0
3Display Results1661660.0602766.7
 (SQL Overall)1786911667.82622833.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.