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

147 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
deflects1433673(None) 
defects134511521def_ects
deflect13399971deflect_
reflects13288871reflects
beflecks1943752beflecks
defeats113511232def_eats
defect124816172def_ect_
defleas1147222defle_as
deflected1635982deflected
deflector1555062deflector
deflectors1654772deflectors
dejects17389222de_jects
delicts104012252de_licts
deselects1244492deselects
detects104011092de_tects
dialects11126002dialects
effects1535282_effects
elects83315002_e_lects
inflects1336192inflects
neglects1144382neglects
reelects103110882reelects
refects124012742ref_ects
reflect123913712reflect_
reflets103513152refle_ts
selects91912142se_lects
affects1535393_affects
afflicts1644003afflicts
analects1047703analects
befleas1236973befle_as
befleck1843943beflec_k
befrets1237613befre_ts
coeffects1942463coeffects
collects12279783collects
dealers84118613deale_rs
deceits102810883de_ceits
decocts1237833de_cocts
deducts1166593de_ducts
deets65330243de__e_ts
defacers14237993defacers
defaces133213403def_aces
defats105114553def__ats
defaults1243333defaults
defeat103817163def_eat_
defecate1438793def_ecate
defecates1538593def_ecates
defected15289973def_ected
defector14277953def_ector
defectors15237883def_ectors
defences1439633defences
defends12358773def_ends
deferents13269393deferents
defers105116943def_e_rs
deffest14308803deffest_
deficits1447273deficits
defiers113913993defie_rs
defies104624053defie__s
defilers12439473defile_rs
defiles114016843defile__s
deflate113613943defl_ate
deflates123013943deflates
deflea1037443defle__a
defleaed1344953defleaed
deflecting1736503deflecting
deflection16147733deflection
deflections17187323deflections
deflective1956093deflective
deflexed2043883deflexed
defocus1335283def_ocus
deforces14248403deforces
deforests1344373deforests
defrocks1844113defrocks
defrosts1244833defrosts
deftest112611713deftest_
defuels11296983defue_ls
defunct1345773defunct_
deject164512843de_ject_
dejecta17376363de_jecta
deleads9379703de_leads
deles65139253de_le__s
delete73620703de_le_te
deletes83117933de_letes
delfts10439673de_l_fts
delict94320333de_lict_
delists84414173de_lists
delts65731793de_l__ts
dements103016623de_ments
depicts12358463de_picts
deplete103010423deple_te
depletes112810643depletes
derelicts12154183derelicts
descents112511203descents
deselect1147523deselect_
deserts82513053de_serts
desserts9247923desserts
detect94217403de_tect_
detents83615153de_tents
detests83711743de_tests
detracts11138833detracts
devests114410473de_vests
dewless1137473dewle_ss
dialect101210263dialect_
directs102710263d_irects
disjects18275923disjects
dissects11279243dissects
dulcets1046283d_ulcets
effect1437443_effect_
ejects15409953_e_jects
elect74327033_e_lect_
erects84116183_e_rects
expects1866883_expects
exsects1655573_exsects
flecks154310803__flecks
fleets96915063__fleets
genuflects1651013genuflects
idiolects1243083idiolects
infects12279713inf_ects
inflect1249223inflect_
inflicts1345613inflicts
leaflets11244813leafle_ts
neglect1047363neglect_
pellets94014783pelle_ts
perfects15107353perfects
preelects1356083preelects
prefects1598133pref_ects
prelects1299723prelects
redefects1543793redef_ects
reejects17336083reejects
reelect911515633reelect_
reerects10319923reerects
refect114319333ref_ect_
reflected1547983reflected
reflector1445733reflector
reflectors1545503reflectors
reflet94024233refle_t_
reflexes1865933reflexes
refloats1156913refloats
refracts13137383refracts
reglets83512983regle_ts
rejects163910693re_jects
relents74018503re_lents
relets64025673re_le_ts
relicts94414593re_licts
relucts9369673re_lucts
resects94115593re_sects
reselects1156413reselects
respects1247703respects
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.440406115.9
2DLD Change Limit1461621477.62319173.8
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.12621990.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.