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

195 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
reflects1328887(None) 
deflects14336731deflects
reelects103110881reelects
refects124012741ref_ects
reflect123913711reflect_
reflets103513151refle_ts
beflecks1943752beflecks
defects134511522def_ects
deflect13399972deflect_
effects1535282_effects
elects83315002_e_lects
inflects1336192inflects
neglects1144382neglects
preelects1356082preelects
prefects1598132pref_ects
prelects1299722pre_lects
reejects17336082reejects
reelect911515632reelect_
reerects10319922reerects
refect114319332ref_ect_
reflected1547982reflected
reflector1445732reflector
reflectors1545502reflectors
reflet94024232refle_t_
reflexes1865932reflexes
refloats1156912refloats
refracts13137382refracts
reglets83512982regle_ts
rejects163910692re_jects
relents74018502re_lents
relets64025672re_le_ts
relicts94414592re_licts
relucts9369672re_lucts
resects94115592re_sects
reselects1156412reselects
respects1247702respects
selects91912142se_lects
affects1535393_affects
afflicts1644003afflicts
analects1047703analects
befleas1236973befle_as
befleck1843943beflec_k
befrets1237613befre_ts
coeffects1942463coeffects
collects12279783collects
defeats113511233def_eats
defect124816173def_ect_
defleas1147223defle_as
deflected1635983deflected
deflector1555063deflector
deflectors1654773deflectors
dejects17389223de_jects
delicts104012253de_licts
deselects1244493deselects
detects104011093de_tects
dialects11126003dialects
effect1437443_effect_
ejects15409953_e_jects
elect74327033_e_lect_
erects84116183_e_rects
expects1866883_expects
exsects1655573_exsects
flecks154310803__flecks
fleets96915063__fleets
genuflects1651013genuflects
infects12279713inf_ects
inflect1249223inflect_
inflicts1345613inflicts
leaflets11244813leafle_ts
neglect1047363neglect_
pellets94014783pelle_ts
perfects15107353perfects
praefects1642873praef_ects
praelects1354353praelects
preelect1249643preelect_
preerects1345413preerects
prefect141011073pref_ect_
prelect111013833pre_lect_
preselects1464363preselects
reacts83616603re__acts
reagents959623reagents
reales64934123reale__s
realest73322433realest_
realists83014843realists
reallots837993reallots
rebecks15288013re_becks
rebecs103913673re_bec_s
reblends1135293reblends
reblent9614253reblent_
recepts113010263re_cepts
recheats1339193recheats
rechecks1944553rechecks
recleans1037513recleans
recollects1443683recollects
redacts10510943re_dacts
redefects1543793redefects
redirects12125103redirects
redlegs936823redle_gs
rednecks1544013rednecks
reeject16349623reeject_
reelected1238313reelected
reelers73520273reele_rs
reenacts1036993reenacts
reerect92915883reerect_
reests64618893re__ests
refaces123216743ref_aces
refected142311663ref_ected
refeeds11368973ref_eeds
refeels10379693ref_eels
refels94618053ref_e_ls
refelt94521423ref_elt_
refences13311843refences
referents12259643referents
refers93921083ref_e_rs
refights1555883refights
refiles104122423refile__s
refits94017653ref__its
reflags1156953refl_ags
reflate103516263refl_ate
reflates113115663reflates
reflecting1638823reflecting
reflection15168993reflection
reflections16178553reflections
reflective1857123reflective
reflew12389453refle__w
reflex16359513refle__x
reflexed1975253reflexed
reflexly2142463reflexly
reflies104418533refl_ies
refloat10310833refloat_
refloods1245553refloods
reflows13258983refl_ows
refluences1545513refluences
refluent1147433refluent_
refluxes1855183refluxes
refocus1236973ref_ocus
reforests1245533reforests
refract121311603refract_
refronts1137773refronts
refuels10399523refue_ls
regents83416543re_gents
reglet73724233regle_t_
regreets9287853regreets
regrets83212923regre_ts
reheats104513523re_heats
reinfects1444723reinfects
reinjects1844023reinjects
reject154116283re_ject_
relaces93420883re_laces
relends84013253re_lends
relent64431853re_lent_
relet54749823re_le_t_
releves103914973re_leves
relics84517903re_lic_s
relict83623903re_lict_
relists73817053re_lists
rellenos8125493rellenos
relocks134411293re_locks
reluct83916113re_luct_
remeets93712413re_meets
remelts93511493re_melts
renests74014213re_nests
rennets75212633renne_ts
reobjects2062003reobjects
repeats94316053re_peats
repents93717623re_pents
replaces123114123replaces
replants102811243replants
repleads11357213repleads
replete92912993reple_te
repletes102812473repletes
replicas1237093replicas
replots93412633repl_ots
requests1735743requests
rerents73319423re_rents
reseats74319583re_seats
resect84424703re_sect_
reselect1059943reselect_
resents74221223re_sents
resets65427613re_se_ts
resmelts1046143resmelts
respect11412033respect_
retests73813853re_tests
retracts101111313retracts
retreats8311413retreats
reverts104715043re_verts
revests104413733re_vests
revets94022173re_ve_ts
rewets94617213re_we_ts
riblets93412553rible_ts
riflers103512193rifle_rs
rifles94217703rifle__s
rillets74216153rille_ts
runlets73310773runle_ts
select82621173se_lect_

Search took 9 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.436409841.7
2DLD Change Limit1461621958.03018202.0
3Display Results1951950.0802437.5
 (SQL Overall)1786911958.54620909.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.