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

221 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
defense113750(None) 
defence1339891defence
defensed1336221defensed
defenses1237911defenses
deafens11317252deafens_
decease1049522decease
defenced1537202defenced
defences1439632defences
defend113910492defen_d
defended1437222defended
defender1337292defender
defends12358772defends
defensive1645002defensive
defers105116942defers_
define104718142defin_e
defines114118682defines
defuse105712722def_use
demesne1035572demesne
dense65923502d__ense
detente83313602detente
offense1343682offense
refence12312242refence
cense75121403__cense
davens104612913davens_
deadens93410693deadens_
deafen10389673deafen__
deafened1335853deafened
deafest112911513deafe_st
deafness1236213deafness
deans66131393de_ans_
debase94014473de_base
debone93714783debon_e
debones103315113debones
decane93818873decan_e
decanes103118913decanes
deceased1247723deceased
deceases11410153deceases
deceive1337813deceive
decency1537453decency
decent94023703decen_t
decenter112412163decenter
decentre11248553decentre
decerns10119053decerns_
decrease1136573decrease
dedans85915073dedans_
deeds75423763de_eds_
deems85421773de_ems_
deepens10307813deepens_
deeps84921773de_eps_
deers64930523de_ers_
dees56356633de_e_s_
deets65330243de_ets_
deface123113863def_ace
defaces133213403defaces
defame123212433def_ame
defames132812253defames
defang1137753defan_g
defanged1435433defanged
defangs1235363defangs
defats105114553defats_
defeat103817163defe_at
defeated132812163defeated
defeater122611663defeater
defeats113511233defeats
defecate1438793defecate
defect124816173defe_ct
defected15289973defected
defects134511523defects
defenders1436363defenders
defenseman1651563defenseman
defensemen1652723defensemen
defensible1644593defensible
defensing14217003defensing
defensives1743873defensives
defer94619753defe__r
deference1578493deference
deferred13106363deferred
deferrer12135593deferrer
deffest14308813deffest
defiance1477633defiance
defiers113913993defiers_
defies104624053defies_
defile105216663def_ile
defiles114016843defiles
defined123813823defined
definer114413773definer
definite1239333definite
defis96717503def_is_
deflate113613943deflate
defleas1147223defleas_
defogs1156683defogs_
deforce13267243deforce
defrost1139553defrost
deftest112611713deftest
deftness1236303deftness
defuels11296983defuels_
defunct1345773defunct
defund11447983defun_d
defunded1435163defunded
defunds12376753defunds
defused125211093def_used
defuser115110503def_user
defuses114814593def_uses
defuze19487843def_uze
defuzes20398303defuzes
degender1136893degender
degrease1045413degrease
deigns8389983deigns_
dekes105224453deke_s_
deleave1147723deleave
deles65139253dele_s_
delete73620703dele_te
deletes83117933deletes
delouse839833delouse
demeans1039723demeans_
dement93825153demen_t
demented12311273demented
dements103016623dements
demerge11168023demerge
demes86032693deme_s_
demesnes1137083demesnes
demise94618323de_mise
demonise11411933demonise
demons94917723demons_
dene56643413d__en_e
denes65639723dene_s_
dens55945073d__ens_
denser74115193d__enser
depend103510923depen_d
depended1337983depended
depends11348993depends
depone93616553depon_e
depones103717093depones
depose94215763de_pose
derange939813derange
deserve11108703deserve
desexes1537833desexes
despise1038683despise
detent73624483deten_t
detentes92712873detentes
detents83615153detents
deterge9118463deterge
deters74724683deters_
detest74122843dete_st
detinue85010033detinue
deveins1138813deveins_
devels104313903devels_
devest104418703deve_st
devise104215753de_vise
devons104512253devons_
dewans105215143dewans_
dexes135224513dexe_s_
diene65720133d_ien_e
dienes75719903d_ienes
diffuse1444383diffuse
disease83213843disease
diseuse83110723diseuse
dispense11129783dispense
diverse11429993diverse
dizens164911393dizens_
dovens104413903dovens_
doyenne1143883doyenne
doyens104810223doyens_
dozens164612463dozens_
duende836923d_uende
effuse1234963_effuse
evens84817103_evens_
expense16127873expense
fease84824873__fease
fence105319913__fence
fens76139763__fens_
fesse86116333__fesse
flense938903_flense
geese64316003ge_e_se
immense1135293immense
incense92410303incense
intense72511903intense
jefes155613673jefe_s_
keens95721183ke_ens_
ketene106613003keten_e
ketenes114813503ketenes
lebens8310093lebens_
lense54523433__lense
license9148423license
mense75025633__mense
nondefense1452823nondefense
offence1545353offence
offenses1443833offenses
peens76428193pe_ens_
prepense12238943prepense
pretense10199823pretense
refels94618053refels_
refenced1439003refenced
refences13311853refences
referee101615753referee
refers93921083refers_
refine95225693refin_e
refines105426343refines
refuse94817513ref_use
release7312763release
retene69224273reten_e
retenes76324623retenes
revenge1138573revenge
revenue1039533revenue
reverse103913743reverse
semens84616973semens_
sense55526823__sense
serene63522353seren_e
serenes73222903serenes
sevens93813663sevens_
spense83912433_spense
teens56227483te_ens_
teensy9478273te_ensy
tense55225843__tense
unfence1239193unfence
venene92912523venen_e
venenes102712133venenes
venenose1144023venenose
weenie92612023we_enie
weens85224053we_ens_
weensy12416823we_ensy

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 Limit1340272216.84319586.0
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.32924381.4
 
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.