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

236 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
reflect12391371(None) 
deflect13399971deflect
reelect911515631reelect
refect114319331ref_ect
reflects13288871reflects
reflet94024231refle_t
befleck1843942befleck
defect124816172def_ect
deflects14336732deflects
effect1437442_effect
elect74327032_e_lect
inflect1249222inflect
neglect1047362neglect
preelect1249642preelect
prefect141011072pref_ect
prelect111013832pre_lect
realest73322432realest
reblent9614252reblent
reeject16349622reeject
reelects103110882reelects
reerect92915882reerect
refects124012742ref_ects
refelt94521422ref_elt
reflected1547982reflected
reflector1445732reflector
reflets103513152reflets
reflew12389452refle_w
reflex16359512refle_x
refloat10310832refloat
refluent1147442refluent
refract121311602refract
reglet73724232regle_t
reject154116282re_ject
relent64431852re_lent
relet54749822re_le_t
relict83623902re_lict
reluct83916112re_luct
resect84424702re_sect
reselect1059942reselect
respect11412032respect
select82621172se_lect
affect1448903_affect
afflict1547043afflict
beflea1147123befle_a
befleas1236973befleas
beflecks1943753beflecks
befret11315963befre_t
coeffect1843933coeffect
collect113314593collect
defeat103817163def_eat
defects134511523def_ects
deffest14308813deffest
deflea1037443defle_a
defleas1147223defleas
deflected1635983deflected
deflector1555063deflector
deftest112611713deftest
defunct1345773defunct
deject164512843de_ject
delict94320333de_lict
deselect1147523deselect
detect94217403de_tect
dialect101210263dialect
effects1535283_effects
eject145016043_e_ject
elects83315003_e_lects
erect74129333_e_rect
expect1758903_expect
exsect1558503_exsect
fellest10313753fellest
fleck148213593__fleck
fleet85932333__fleet
genuflect1551953genuflect
infect113413443inf_ect
inflects1336203inflects
inflict1248623inflict
kreplech1941583kreplech
leaflet10199743leafle_t
leftest10269463leftest
neglects1144383neglects
pellet83326553pelle_t
perfect141010833perfect
praefect1544773praef_ect
praelect1247533praelect
preelects1356083preelects
preerect1259273preerect
prefects1598133pref_ects
prelects1299723pre_lects
preselect1346983preselect
react74634333re__act
reagent8716603reagent
realer63528593reale_r
reales64934123reale_s
realist73225383realist
reallot7312133reallot
rebec94416543re_bec_
rebeck14419913re_beck
rebecs103913673re_becs
reblend1036653reblend
recent83630853re_cent
recept103319083re_cept
recheat12415933recheat
recheck1835613recheck
reclean938523reclean
recollect1345703recollect
redact9419043re_dact
reddest9311953reddest
redefect1446053redefect
redirect11147993redirect
redleg839273redle_g
redlegs936823redlegs
redneck1445113redneck
redolent9411883redolent
reefiest112811483reefiest
reejects17336083reejects
reelected1238313reelected
reeled74725533reele_d
reeler63822573reele_r
reelers73520273reelers
reenact9413013reenact
reerects10319923reerects
reest54938093re__est
reface113616353ref_ace
refaced133713573refaced
refaces123216743refaces
refected142311663ref_ected
refed93921923ref_e_d
refeed104717623ref_eed
refeeds11368973refeeds
refeel93913243ref_eel
refeels10379693refeels
refel84920813ref_e_l
refell94214443ref_ell
refels94618053ref_els
refence12312243refence
refer84822143ref_e_r
referent112813423referent
refers93921083ref_ers
reffed134712513reffe_d
refight1488873refight
refile95122373refile__
refiled114318653refile_d
refiles104122423refile_s
refit84230063ref__it
reflag1098083refl_ag
reflags1156953reflags
reflate103516263reflate
reflecting1638823reflecting
reflection15168993reflection
reflective1857123reflective
reflectors1545503reflectors
reflexed1975253reflexed
reflexes1865933reflexes
reflexly2142463reflexly
reflies104418533reflies
refloats1156913refloats
reflood1136363reflood
reflow12379653refl_ow
reflown13316213reflown
reflows13258983reflows
refluence1445863refluence
reflux16315413refl_ux
refly113914563refl__y
reforest1139963reforest
refracts13137383refracts
refresh1335453refresh
refront10313263refront
reft75141273ref___t
refuel93912623refue_l
refuels10399523refuels
refulgent1345403refulgent
regent74127673re_gent
reglets83512983reglets
regreet83015953regreet
regret73723533regre_t
reheat94423943re_heat
reinfect1346483reinfect
reinject1745543reinject
rejects163910693re_jects
relace83122153re_lace
relend76116453re_lend
relents74018503re_lents
relets64025673re_lets
releve95116403re_leve
relic74623363re_lic_
relics84517903re_lics
relicts94414593re_licts
relist64628413re_list
relit55340683re_l_it
relleno796463relleno
relock124713523re_lock
relucts9369673re_lucts
remeet86325473re_meet
remelt85123123re_melt
remet74843723re_me_t
renest64529713re_nest
rennet64624853renne_t
reobject1953113reobject
repeat85127213re_peat
repent84728873re_pent
replace113214283replace
replant93318533replant
replead10399013replead
repled93319783reple_d
replete92912993replete
replevy1533473replevy
replica1137943replica
replot83818593repl_ot
request16311023request
rerent63832453re_rent
reseat64131493re_seat
resects94115593re_sects
reselects1156413reselects
resent63833623re_sent
reset55051863re_se_t
resmelt9411773resmelt
respects1247703respects
respelt9312143respelt
retest64028453re_test
retract91318113retract
retreat7317533retreat
revert93529113re_vert
revest94623603re_vest
revet84938843re_ve_t
rewet85135153re_we_t
riblet84222443rible_t
rifest93114583rif_est
rifle85518333rifle__
rifled104115003rifle_d
rifler94014263rifle_r
riflers103512203riflers
riflery13345803riflery
rifles94217713rifle_s
rillet64828853rille_t
runlet63821413runle_t
selects91912143se_lects

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 Limit1340272367.20318607.1
3Display Results2362360.0763105.3
 (SQL Overall)1786912367.68523251.9
 
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.