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

175 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
defence133989(None) 
defenced1537201defenced
defences1439631defences
defense1137501defense
refence12312231refence
decency1537452decency
deface123113862def_ace
defect124816172defe_ct
defend113910492defen_d
defended1437222defended
defender1337292defender
defends12358772defends
defensed1336222defensed
defenses1237912defenses
deference1578492deference
defiance1477632defiance
define104718142defin_e
deforce13267242deforce
defunct1345772defunct
detente83313602detente
fence105319912__fence
offence1545352offence
refenced1438992refenced
refences13311842refences
unfence1239192unfence
absence1137713absence
adherence1564893adherence
bedunce1235683bedunce
cadence1239063cadence
credence1387823credence
dance85223133d__ance
deafen10389673deafen__
deafened1335853deafened
deafens11317253deafen_s
debone93714783debon_e
decadence1555593decadence
decane93818873decan_e
decease1049523decease
deceive1337813deceive
decencies1448943decencies
decent94023703decen_t
decenter112412163decenter
decentre11248553decentre
deduce1079253de_duce
defaced142910973def_aced
defacer132810363def_acer
defaces133213403def_aces
defame123212433def_ame
defang1137753defan_g
defanged1435433defanged
defangs1235363defangs
defeasance1652543defeasance
defeat103817163defe_at
defeated132812163defeated
defeater122611663defeater
defeats113511233defeats
defecate1438793defecate
defected15289973defected
defects134511523defects
defenceman1851653defenceman
defencemen1852613defencemen
defencing16226693defencing
defenders1436363defenders
defensive1645003defensive
defer94619753defe__r
deferences1677873deferences
deferred13106363deferred
deferrer12135593deferrer
defers105116943defe_rs
defiances1557033defiances
defile105216663def_ile
defined123813823defined
definer114413773definer
defines114118683defines
definite1239333definite
deflate113613943deflate
deflect13399973deflect
deforced15247373deforced
deforcer14246903deforcer
deforces14248403deforces
defrock1744643defrock
defund11447983defun_d
defunded1435163defunded
defunds12376753defunds
defuse105712723def_use
defuze19487843def_uze
degender1136893degender
dehisce13104273dehisce
deice84320033d__eice
deject164512843deje_ct
deleave1147723deleave
delete73620703dele_te
dement93825153demen_t
demented12311273demented
dements103016623dements
demerge11168023demerge
demesne1035573demesne
dene56643413d__en_e
denounce1145103denounce
dense65923503d__ense
depend103510923depen_d
depended1337983depended
depends11348993depends
depone93616553depon_e
derange939813derange
deserve11108703deserve
desinence1257503desinence
detect94217403dete_ct
detent73624483deten_t
detentes92712873detentes
detents83615153detents
deterge9118463deterge
detinue85010033detinue
deuce84517493d__euce
deviance1477083deviance
device124512163de_vice
devoice13347343devoice
dezinc1836053dezinc_
dezinced2183903dezinced
dezincs1933753dezincs
diene65720133d_ien_e
doyenne1143883doyenne
drench12369593d_rench
duende836923d_uende
dunce86319263d__unce
durance1059113durance
efface14366673_efface
essence947673essence
evince1137763_evince
faience1237513faience
fenced124412713__fenced
fencer114613533__fencer
fences114617113__fences
hence104920043__hence
ketene106613003keten_e
lenience1048333lenience
licence11119363licence
lucence11148003lucence
mergence13137943mergence
offences1645023offences
offense1343683offense
outfence1356973outfence
penance11313443penance
pence94924453__pence
potence11711363potence
presence122213513presence
pretence122312123pretence
recency1438633recency
reface113616353ref_ace
refect114319333refe_ct
referee101615753referee
reference14810093reference
refine95225693refin_e
refluence1445853refluence
regency1337363regency
retene69224273reten_e
revenge1138573revenge
revenue1039533revenue
science1138783science
seance83716693se_ance
sentence1099863sentence
sequence1946903sequence
serene63522353seren_e
silence9310213silence
spence103813793_spence
tendence1148523tendence
tenpence1246403tenpence
thence112010843_thence
unfenced1437733unfenced
unfences1337933unfences
valence1268773valence
venene92912523venen_e
vergence14128273vergence
weenie92612023we_enie
whence14187923_whence

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.406440125.6
2DLD Change Limit1340271756.22021547.7
3Display Results1751750.0602916.7
 (SQL Overall)1786911756.68626726.1
 
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.