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

185 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
defenses123791(None) 
defences1439631defences
defense1137501defense_
defensed1336221defensed
deceases11410152deceases
defence1339892defence_
defenced1537202defenced
defended1437222defended
defender1337292defender
defenders1436362defenders
defends12358772defen_ds
defensives1743862defensives
defines114118682defin_es
deftness1236302deftness
defuses114814592def_uses
demesnes1137082demesnes
detentes92712872detentes
offenses1443832offenses
refences13311842refences
avenses1049643_avenses
censes83721803__censes
cereuses1049243cereuses
daftness1235533daftness
deadness1039233deadness
deafened1335853deafen_ed
deafens11317253deafen__s
deafness1236213deafnes_s
deafnesses1436223deafnesses
dearness939973dearness
debases103814133de_bases
debones103315113debon_es
decanes103118913decan_es
decease1049523decease_
deceased1247713deceased
deceives1437903deceives
decencies1448943decencies
decenter112412163decenter
decenters122410373decenters
decentest1249083decentest
decentres12238523decentres
decreases1237223decreases
deepness1136443deepness
defaces133213403def_aces
defames132812253def_ames
defanged1435433defanged
defangs1235363defan_gs
defeated132812163defeated
defeater122611663defeater
defeaters13289103defeaters
defeats113511233defe_ats
defecates1538593defecates
defected15289973defected
defects134511523defe_cts
defend113910493defen__d
defenseless1551893defenseless
defenseman1651553defenseman
defensemen1652723defensemen
defensing14217003defensing
defensive1644993defensive
deferences1677873deferences
deferred13106363deferred
deferrer12135593deferrer
deferrers13115153deferrers
defers105116943defe__rs
defiances1557033defiances
defies104624053def__ies
defiles114016843def_iles
define104718143defin_e_
defined123813823defin_ed
definer114413773defin_er
definers124211193definers
definiens1345303definiens
deflates123013943deflates
defocuses15134493defocuses
deforces14248403deforces
defrosts1244833defrosts
deftnesses1436813deftnesses
defunded1435163defunded
defunds12376753defun_ds
defuse105712723def_use_
defused125211093def_used
defuser115110503def_user
defusers12487363def_users
defuzes20398303def_uzes
degases93413103de_gases
degasses10278363degasses
degender1136893degender
degenders1236083degenders
degreases1146153degreases
deixises1635693deixises
deleaves1248063deleaves
deletes83117933dele_tes
delouses9310013delouses
demented12311273demented
dements103016623demen_ts
demerges12129503demerges
demesne1035573demesne_
demises103719563de_mises
demoness1138053demoness
demonises12311093demonises
demoses103815823de_moses
denes65639723d__en_es
denies74729643d__enies
dense65923503d__ense_
denseness1046863denseness
denser74115193d__enser
densest83112473d__ensest
depended1337983depended
depends11348993depen_ds
depones103717093depon_es
deposes103117213de_poses
depresses1259883depresses
deranges1039973deranges
dermises112512023dermises
derrises93012783derrises
deserves12109893deserves
desexes1537833dese_xes
despises1139433despises
detente83313603detente_
detents83615153deten_ts
deterges101510093deterges
detests83711743dete_sts
detinues9569823detinues
devests114410473deve_sts
devises114116763de_vises
dewiness1238453dewiness
dickenses1645073dickenses
dienes75719903d_ien_es
diereses938693diere_ses
dieses75218693d_ie_ses
diffuses1534823diffuses
digeneses1147393digeneses
direness9311303direness
diseases92415813diseases
diseuses93112763diseuses
dispenses121210763dispenses
doneness9411513doneness
doyennes1244363doyennes
dresses83716173d_resses
duendes938193d_uendes
dueness82310123d_ueness
duenesses1039333duenesses
dufuses11436593duf_uses
duresses939173duresses
effuses1335903_effuses
elevenses1244333elevenses
emeses86114963_eme_ses
expenses17138373expenses
feases95422923__feases
fences114617113__fences
fesses94820253__fesses
flenses1039473_flenses
geneses82613523gene_ses
incenses102411003incenses
ketenes114813503keten_es
lenses64620893__lenses
licenses10118923licenses
menses84222453__menses
nemeses948663neme_ses
offences1645023offences
offense1343683offense_
pretenses112210593pretenses
recesses10312323recesses
redenies9615713redenies
refence12312233refence_
refenced1438993refenced
referees111310413referees
refines105426343refin_es
refuses104918553ref_uses
releases8313343releases
retenes76324623reten_es
revenges1238983revenges
revenues1138663revenues
reverses112513513reverses
rifeness1138583rifeness
safeness11239633safeness
selenoses947463selenoses
senses63923943__senses
serenes73222903seren_es
spenses92913573_spenses
teleses7313123tele_ses
tenses64722553__tenses
unfences1337933unfences
venenes102712133venen_es
weenies102915093we_enies

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621856.47022590.7
3Display Results1851850.0632936.5
 (SQL Overall)1786911856.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.