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

252 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
dejects1738922(None) 
defects134511521defects
deject164512841deject_
dejecta17376361dejecta
detects104011091detects
ejects15409951_ejects
rejects163910691rejects
deceits102810882deceits
decocts1237832decocts
deducts1166592deducts
deets65330242de_e_ts
defeats113511232defeats
defect124816172defect_
deflects14336732deflects
dejected19307592dejected
delicts104012252delicts
dements103016622dements
depicts12358462depicts
deserts82513052deserts
detect94217402detect_
detents83615152detents
detests83711742detests
devests114410472devests
directs102710262directs
disjects18275922disjects
eject145016042_eject_
ejecta15337392_ejecta
elects83315002_elects
erects84116182_erects
injects16257452injects
objects18123692objects
reejects17336082reejects
refects124012742refects
reject154116282reject_
resects94115592resects
selects91912142selects
abject17137703abject_
advects13276013advects
affects1535393affects
aspects1146743aspects
bedecks1635793bedecks
beets76131443be_e_ts
begets96215523bege_ts
behests1235953behests
bejesus1643693bejesus
berets85822523bere_ts
besets85718803bese_ts
bisects1137133bisects
cements112714223cements
coerects1258543coerects
debeaks1436103debeaks
debits94214503de_bits
debts86418373d__ebts
debuts93911753de_buts
decants103514443decants
deceit93018213deceit_
decent94023703decent_
decerns10119053decerns
decks124822193d__ecks
decoct11313783decoct_
decos85522123d__ecos
deduces1168793deduces
deduct10610793deduct_
deeds75423763de_e_ds
deejays1843433deejays
deems85421773de_e_ms
deeps84921773de_e_ps
deers64930523de_e_rs
dees56356633de_e__s
deet57356583de_e_t_
defaces133213403defaces
defats105114553de_fats
defeat103817163defeat_
defecate1438793defecate
defecates1538593defecates
defected15289973defected
defector14277953defector
defectors15237883defectors
defences1439633defences
defends12358773defends
defers105116943defe_rs
deficits1447273deficits
deflect13399973deflect_
defocus1335283defocus
degerms1135623degerms
degusts936063degusts
dehorts11379773dehorts
deicers103612733deicers
deices94119373de_ices
deists74916433de_ists
dejecting20217793dejecting
dejection19178663dejection
dejections20168353dejections
dekes105224453deke__s
deleads9379703deleads
deles65139253dele__s
delete73620703dele_te
deletes83117933deletes
delfts10439673de_lfts
delict94320333delict_
delists84414173delists
delts65731793d__elts
demasts1089223demasts
demeans1039723demeans
dement93825153dement_
demerits11310763demerits
demes86032693deme__s
demits94918073de_mits
denes65639723dene__s
dents65031803d__ents
departs104310683departs
depends11348993depends
deperms1236603deperms
depict113514793depict_
deports105012883deports
depots94716343de_pots
derats74625063de_rats
derelicts12154183derelicts
desalts839573desalts
descents112511203descents
deselects1244493deselects
desert72725493desert_
desexes1537833desexes
desists83611723desists
despots10319683despots
desserts9247923desserts
detected12289733detected
detecter11298733detecter
detecters12217753detecters
detector11278323detector
detectors12278303detectors
detent73624483detent_
detente83313603detente
detentes92712873detentes
deters74724683dete_rs
detest74122843detest_
deticks1437353deticks
detracts11138833detracts
deuces94015513de_uces
deveins1138813deveins
devels104313903deve_ls
devest104418703devest_
devices133212583devices
dexes135224513dexe__s
dialects11126003dialects
didacts1186063didacts
diets66026643d_ie_ts
digests93610613digests
direct93817333direct_
disject17268673disject_
dissects11279243dissects
diverts114412033diverts
divests114510933divests
docents102810803docents
dovecots1444323dovecots
drecks13459203d_recks
ducts85319893d__ucts
duets65323883d_ue_ts
dulcets1046283dulcets
duvets1039223duve_ts
edicts94911703_edicts
educts9439893_educts
effects1535283effects
egests74411253_egests
ejected17297653_ejected
ejector16378603_ejector
ejectors17328663_ejectors
elect74327033_elect_
enacts84012973_enacts
epacts105010393_epacts
erect74129333_erect_
eructs83610793_eructs
events94814073_events
everts94514893_everts
evicts11368553_evicts
exacts15359613_exacts
execs14539723_exec_s
exerts133712293_exerts
expects1866883expects
exsects1655573exsects
geests75912163ge_ests
genets75716663gene_ts
gerents82612923gerents
infects12279713infects
inject153210233inject_
insects93710843insects
jests125922453__jests
jets115834103__je_ts
keets95123483ke_e_ts
leets54927123le_e_ts
meets74224613me_e_ts
neglects1144383neglects
object17135803object_
objets15125323obje_ts
perfects15107353perfects
prefects1598133prefects
prelects1299723prelects
projects1936413projects
reacts83616603re_acts
rebecks15288013rebecks
rebecs103913673rebec_s
recepts113010263recepts
redacts10510943redacts
redefects1543793redefects
reeject16349623reeject_
reelects103110883reelects
reerects10319923reerects
reests64618893re_ests
refect114319333refect_
reflects13288873reflects
regents83416543regents
reheats104513523reheats
reinjects1844023reinjects
rejected182710113rejected
rejectee17289623rejectee
rejectees18235423rejectees
rejecter17258943rejecter
rejecters18257543rejecters
rejector17237723rejector
rejectors18247613rejectors
relents74018503relents
relets64025673rele_ts
relicts94414593relicts
relucts9369673relucts
remeets93712413remeets
remelts93511493remelts
renests74014213renests
reobjects2062003reobjects
repeats94316053repeats
repents93717623repents
rerents73319423rerents
reseats74319583reseats
resect84424703resect_
resents74221223resents
resets65427613rese_ts
respects1247703respects
retests73813853retests
reverts104715043reverts
revests104413733revests
revets94022173reve_ts
rewets94617213rewe_ts
sects75622893__sects
select82621173select_
senecas939013senecas
subjects19226533subjects
tenets65518953tene_ts
tercets93512443tercets
trajects1744533trajects
weets85427723we_e_ts
xebecs17355363xebec_s
zebecks24274193zebecks
zebecs19316183zebec_s

Search took 7 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.390458182.1
2DLD Change Limit1340272526.17321711.8
3Display Results2522520.0932709.7
 (SQL Overall)1786912526.65626846.6
 
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.