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

189 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
refract12131160(None) 
refracts13137381refracts
retract91318111retract
detract101414632detract
infract12610002infract
react74634332re__act
redact9419042re_dact
redraft11310572redraft
reenact9413012reenact
reerect92915882reerect
reface113616352ref_ace
refect114319332ref_ect
reflect123913712reflect
refracted1557392refracted
refractor14156322refractor
refrain10310042refrain
reframe1239392reframe
refront10313262refront
regraft11310152regraft
regrant8317322regrant
rerack122513162re_rack
retrace91417342retrace
retrack131310722retrack
retracts101111312retracts
retroact10410002retroact
rewrapt12138112rewrapt
artefact1345183artef_act
attract9511833attract
bearcat11611913bearcat
befret11315963befr_et
bewrapt14147133bewrapt
bract96332723__bract
deface123113863def_ace
defat95426693def_a_t
defeat103817163defea_t
defect124816173def_ect
defiant11311923defiant
deflect13399973deflect
defrag1136463defra_g
defrags1236193defrags
defraud1243913defraud
defray1337643defra_y
defrays1436113defrays
defrock1744643defrock
defrost1139553defrost
defunct1345773defunct
derat65044083de_ra_t
detracts11138833detracts
diffract1744733diffract
efface14366673_efface
effect1437443_effect
enact73525363_e_nact
enrapt8313013_enrapt
epact94921533_e_pact
erect74129333_e_rect
errant6618733_errant
eruct74022353_e_ruct
exact143516933_e_xact
extract16311013extract
fact97142543__f_act
fracti1139963__fracti
frat75648543__fra_t
infarct1249013infarct
infracts1346623infracts
overact12315043overact
perfect141010833perfect
preact103220393pre__act
predraft1447593predraft
preenact12410183preenact
preerect1259273preerect
preface14510923pref_ace
prefect141011073pref_ect
prefrank1764233prefrank
prerace11414123pre_race
protract12510603protract
reach105123883re__ach
reacts83616603re__acts
readapt1039743readapt
rebait8320403re_bait
reboant9315093reboant
rebranch1545813rebranch
recant83228683re_cant
recast83422773re_cast
rechart12314343rechart
recoat84024273recoa_t
recrate92621663recrate
recreant10311283recreant
recruit939773recruit
redacts10510943re_dacts
redbait1039803redbait
redirect11147993redirect
redrafts1235603redrafts
redraw10269853redra_w
redrawn11245953redrawn
redraws11218473redraws
redreamt11127183redreamt
redroot8312903redroot
reeject16349623reeject
reelect911515633reelect
reenacts1036993reenacts
reerects10319923reerects
refaced133713573ref_aced
refaces123216743ref_aces
refall94314393ref_all
refects124012743ref_ects
refelt94521423ref_elt
refence12312243refence
referent112813423referent
refight1488873refight
refit84230063ref__it
reflag1098083refla_g
reflags1156953reflags
reflate103516263reflate
reflects13288873reflects
reflet94024233ref_let
refloat10310833refloat
reforest1139963reforest
reformat1357653reformat
refractile1544143refractile
refracting1638733refracting
refraction15137903refraction
refractive1846693refractive
refractors15156273refractors
refractory18134773refractory
refrains1139593refrains
reframed1437853reframed
reframes1338993reframes
refresh1335453refresh
refried113513883refried
refries104419733refries
refronts1137773refronts
refroze1956223refroze
refry114412463refr__y
reft75141273ref___t
regnant8312843regnant
regrade92612033regrade
regrafts1235303regrafts
regrants9310013regrants
regrate82618663regrate
regreet83015953regreet
regret73723533regr_et
reheat94423943rehea_t
reject154116283re_ject
relace83122153re_lace
reliant7319243reliant
relict83623903re_lict
reluct83916113re_luct
remnant9312643remnant
repack142412163re_pack
repast83520633re_past
repeat85127213repea_t
replace113214283replace
replant93318533replant
reprice113212833reprice
reprint9318983reprint
reproach1544953reproach
reptant92817073reptant
reracks132310533re_racks
reran57329103re_ra_n
rerent63832453re_rent
resat55139683re_sa_t
reseat64131493resea_t
resect84424703re_sect
respace11310913respace
respect11412033respect
restack1339433restack
restart7320033restart
restrict10313633restrict
retack122612823re_tack
reteach1237413reteach
retirant8313593retirant
retraced111413033retraced
retracer101411883retracer
retraces101417273retraces
retracks14149103retracks
retracted12410953retracted
retractor11218513retractor
retrain7615423retrain
retral64419743retra_l
retreat7317533retreat
retroacts1146283retroacts
rewrap11127533rewra_p
rewraps12136563rewraps
ricrac1037013ricrac_
ricracs1136363ricracs
serac75925203se_rac_
seracs84418573se_racs
terrace93311843terrace
tract75635713__tract

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.406440125.6
2DLD Change Limit1340271896.65620136.3
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.13825033.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.