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

329 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
defects13451152(None) 
defeats113511231defeats
defect124816171defect_
deflects14336731deflects
dejects17389221dejects
detects104011091detects
refects124012741refects
affects1535392affects
deceits102810882deceits
decocts1237832decocts
deducts1166592deducts
deets65330242de_e_ts
defaces133213402defaces
defats105114552def_ats
defeat103817162defeat_
defecate1438792defecate
defecates1538592defecates
defected15289972defected
defector14277952defector
defectors15237882defectors
defences1439632defences
defends12358772defends
defers105116942defe_rs
deficits1447282deficits
deflect13399972deflect_
defocus1335282defocus
deject164512842deject_
dejecta17376362dejecta
delicts104012252delicts
dements103016622dements
depicts12358462depicts
deserts82513052deserts
detect94217402detect_
detents83615152detents
detests83711742detests
devests114410472devests
directs102710262directs
effects1535282effects
ejects15409952_ejects
elects83315002_elects
erects84116182_erects
infects12279712infects
perfects15107352perfects
prefects1598132prefects
redefects1543792redefects
refect114319332refect_
reflects13288872reflects
rejects163910692rejects
resects94115592resects
selects91912142selects
advects13276013advects
affect1448903affect_
aspects1146743aspects
bedecks1635793bedecks
beets76131443be_e_ts
befits114711503bef_its
beflecks1943753beflecks
befrets1237613befrets
begets96215523bege_ts
behests1235953behests
berets85822523bere_ts
besets85718803bese_ts
bisects1137133bisects
cements112714223cements
coeffects1942463coeffects
coerects1258543coerects
confects153110873confects
deafens11317253deafe_ns
deafest112911513deafest_
debeaks1436103debeaks
debits94214503de_bits
debts86418373d__ebts
debuts93911753de_buts
decants103514443decants
deceit93018213deceit_
decent94023703decent_
decerns10119053decerns
decks124822193d__ecks
decoct11313783decoct_
decos85522123d__ecos
deduces1168793deduces
deduct10610793deduct_
deeds75423763de_e_ds
deems85421773de_e_ms
deeps84921773de_e_ps
deers64930523de_e_rs
dees56356633de_e__s
deet57356583de_e_t_
deface123113863defac_e
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defames132812253defames
defangs1235363defangs
defat95426693def_at_
defaults1243333defaults
defeated132812163defeated
defeater122611663defeater
defeaters13289103defeaters
defeatism1544413defeatism
defeatist1356603defeatist
defecated1637493defecated
defecator1546383defecator
defecators1656253defecators
defecting162510223defecting
defection151610643defection
defections161510203defections
defective1848003defective
defectives1945683defectives
defence1339893defence
defenced1537203defenced
defend113910493defe_nd
defense1137503defense
defenses1237913defenses
defer94619753defe__r
deferents13269393deferents
deffest14308813deffest_
deficit1339683deficit
defiers113913993defiers
defies104624053def_ies
defiles114016843defiles
defines114118683defines
defis96717503def__is
deflate113613943deflate
deflates123013943deflates
defleas1147223defleas
deflected1635983deflected
deflector1555063deflector
deflectors1654773deflectors
defoams1336193defoams
defogs1156683def_ogs
deforces14248403deforces
deforests1344373deforests
deforms1337803deforms
defrags1236193defrags
defrays1436113defrays
defrocks1844113defrocks
defrost1139553defrost
defrosts1244833defrosts
deft85540223def__t_
deftest112611713deftest_
defuels11296983defuels
defunct1345773defunct_
defunds12376753defunds
defuses114814593defuses
defuzes20398303defuzes
degerms1135623degerms
degusts936063degusts
dehorts11379773dehorts
deicers103612733deicers
deices94119373de_ices
deists74916433de_ists
dejected19307593dejected
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_
disjects18275923disjects
dissects11279243dissects
diverts114412033diverts
divests114510933divests
docents102810803docents
dovecots1444323dovecots
drecks13459203d_recks
ducts85319893d__ucts
duets65323883d_ue_ts
dulcets1046283dulcets
duvets1039223duve_ts
edicts94911703_edicts
educts9439893_educts
effect1437443effect_
efts76519483_ef__ts
egests74411253_egests
eject145016043_eject_
ejecta15337393_ejecta
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
facts107021893__facts
feats86432753__feats
feces105625363__feces
fecks145417853__fecks
felts85324543__felts
fests85828043__fests
fets75345943__fe_ts
geests75912163ge_ests
genets75716663gene_ts
gerents82612923gerents
hefts116218153hef__ts
infect113413443infect_
infests10279793infests
inflects1336193inflects
injects16257453injects
insects93710843insects
jefes155613673jefe__s
keets95123483ke_e_ts
leets54927123le_e_ts
lefts86517813lef__ts
meets74224613me_e_ts
neglects1144383neglects
objects18123693objects
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
praefects1642873praefects
prefect141011073prefect_
prelects1299723prelects
reacts83616603re_acts
rebecks15288013rebecks
rebecs103913673rebec_s
recepts113010273recepts
redacts10510943redacts
redefeats1344203redefeats
redefect1446053redefect_
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
reests64618893re_ests
refaces123216743refaces
refected142311663refected
refeeds11368973refeeds
refeels10379693refeels
refels94618053refe_ls
refelt94521423refelt_
refences13311853refences
refers93921083refe_rs
refits94017653ref_its
reflect123913713reflect_
reflets103513153reflets
refocus1236973refocus
refracts13137383refracts
regents83416543regents
reheats104513523reheats
reinfects1444723reinfects
reject154116283reject_
relents74018503relents
relets64025673rele_ts
relicts94414593relicts
relucts9369673relucts
remeets93712413remeets
remelts93511493remelts
renests74014213renests
repeats94316053repeats
repents93717623repents
rerents73319423rerents
reseats74319583reseats
resect84424703resect_
resents74221223resents
resets65427613rese_ts
respects1247703respects
retests73813853retests
reverts104715043reverts
revests104413733revests
revets94022173reve_ts
rewets94617213rewe_ts
sects75622893__sects
select82621173select_
senecas939013senecas
tenets65518953tene_ts
tercets93512443tercets
weets85427723we_e_ts
wefts116715493wef__ts
xebecs17355363xebec_s
zebecks24274193zebecks
zebecs19316183zebec_s

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 Limit1340273296.89019452.4
3Display Results3293290.1102990.9
 (SQL Overall)1786913297.40624127.9
 
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.