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

171 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
defenced153720(None) 
defence1339891defence_
defences1439631defences
defended1437221defended
defensed1336221defensed
refenced1438991refenced
deafened1335852deafen_ed
defaced142910972def_aced
defanged1435432defanged
defeated132812162defeated
defected15289972defected
defend113910492defen__d
defender1337292defender
defense1137502defense_
defenses1237912defenses
deferred13106362deferred
defined123813822defin_ed
deforced15247372deforced
defunded1435162defunded
demented12311272demented
depended1337982depended
dezinced2183902dezinced
fenced124412712__fenced
refence12312232refence_
refences13311842refences
unfenced1437732unfenced
bedunced1453903bedunced
cadenced1435523cadenced
cemented1338373cemented
danced105315253d__anced
davened124610073daven_ed
deadened1137233deaden_ed
deaned84620453de_an_ed
debeaked1634613debeaked
deboned113411633debon_ed
debunked1633193debunked
decanted122310493decanted
deceased1247713deceased
deceived1535893deceived
decencies1448943decencies
decency1537453decenc_y
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
deduced1266683de_duced
deeded94615543de_e_ded
deemed104713063de_e_med
deepened1235663deepen_ed
deface123113863def_ace_
defacer132810363def_acer
defaces133213403def_aces
defamed14309833def_amed
defatted1335673defatted
defeater122611663defeater
defecated1637493defecated
defect124816173defe_c_t
defects134511523defe_cts
defenceman1851653defenceman
defencemen1852613defencemen
defencing16226693defencing
defenders1436363defenders
defends12358773defen_ds
deference1578493deference_
deferences1677873deferences
deferrer12135593deferrer
defiance1477633defiance_
defiances1557033defiances
defied115016383def__ied
defiled124013103def_iled
define104718143defin_e_
definer114413773defin_er
defines114118683defin_es
deflated133412303deflated
defleaed1344953defleaed
deflected1635983deflected
deflexed2043883deflexed
defoamed15356243defoamed
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deformed15248263deformed
defrayed1635403defrayed
defrocked2043053defrocked
defueled1374513defueled
defuelled1443123defuelled
defunct1345773defunc_t
defund11447983defun__d
defused125211093def_used
defuzed21447043def_uzed
degender1136893degender
degermed1335453degermed
dehisced1583683dehisced
deiced104214483d__eiced
deigned1037503deign_ed
dejected19307593dejected
deleaded1148333deleaded
deleaved1346573deleaved
deleted93314913dele_ted
demanded13348513demanded
demeaned1237283demeaned
demerged13157603demerged
denied84318633d__enied
denned84215633d__enned
denounced1344033denounced
dented84120513d__ented
depend103510923depen__d
depermed1436453depermed
deponed113712873depon_ed
deranged1137693deranged
desanded11227453desanded
descended1446283descended
deserted101012203deserted
deserved13108133deserved
desexed1636183dese_xed
detected12289733detected
detente83313603detente_
detentes92712873detentes
deterged11127923deterged
deterred10137803deterred
detested10279623detested
deuced104112123d__euced
deveined1336673deveined
develed123611933deve_led
devested13239133devested
devoiced15276063devoiced
dezincked2691643dezincked
dizened18267333dizen_ed
dovened12389063doven_ed
dozened18377453dozen_ed
drenched15247913d_renched
effaced16225573_effaced
emended11329603_emended
evened101010313_even_ed
evinced1335403_evinced
fence105319913__fence_
fencer114613533__fencer
fences114617113__fences
fended114216913__fended
keened114013633ke_en_ed
licenced13145773licenced
offence1545353offence_
offences1645023offences
offended1643653offended
outfenced1555093outfenced
peened94318163pe_en_ed
penanced1338163penanced
redenied10511283redenied
refaced133713573ref_aced
refected142311663refected
refeed104717623refe__ed
refelled122810163refelled
refereed12149693refereed
referenced1676863referenced
referred1297833referred
refined114720003refin_ed
refunded1336953refunded
relented92614943relented
remended123010393remended
repented112614983repented
rerented92516163rerented
resented92716963resented
revenged1337553revenged
revenued1237223revenued
sentenced1256683sentenced
sequenced2144453sequenced
silenced1136273silenced
undefended1644003undefended
unfence1239193unfence_
unfences1337933unfences
weened104013733we_en_ed

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621716.78021557.8
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.27924548.8
 
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.