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

148 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
defensing1421700(None) 
defencing16226691defencing
defending15298351defending
deafening1476272deafen_ing
deceasing1338402deceasing
defanging1535332defanging
defeating142311972defeating
defecting162510222defecting
defensive1644992defensive
deferring1436142deferring
defining133711802defin_ing
defunding15216122defunding
defusing13227932def_using
dementing13311042dementing
depending14208782depending
refencing15188852refencing
cementing1438763cementing
censing104215263__censing
davening13258873daven_ing
deadening1277583deaden_ing
deafenings1562503deafen_ings
deaning94020473de_an_ing
debasing12238063de_basing
debeaking1735923debeaking
deboning12109153debon_ing
debunking1733353debunking
decanting132510633decanting
deceiving1635733deceiving
decentring1446753decentring
decerning1337293decerning
decreasing1446513decreasing
deeding103315123de_e_ding
deeming113913123de_e_ming
deepening1335613deepen_ing
defacing15238683def_acing
defaming15238463def_aming
defatting1436103defatting
defecating17237783defecating
defendant1445433defendant
defense1137503defens__e
defensed1336223defens_ed
defenses1237913defens_es
defensible1644593defensible
defensibly1953723defensibly
defensives1743863defensives
defiling132812463def_iling
deflating142610713deflating
defleaing1444743defleaing
deflecting1736503deflecting
defoaming1645653defoaming
defocusing1752813defocusing
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defraying1735853defraying
defrosting1544493defrosting
defueling14255093defueling
defuelling1573543defuelling
defuzing22195253def_uzing
defying15328823def__ying
degassing1234823degassing
degerming1435753degerming
degreasing1345423degreasing
deigning1137753deign_ing
dejecting20217793dejecting
dekeing13358353deke__ing
deleading1237773deleading
deleaving1436263deleaving
deleing93313953dele__ing
deleting103314423dele_ting
delousing1136303delousing
demanding14237923demanding
demeaning1337243demeaning
demerging1436643demerging
demising122012523de_mising
demonising1447563demonising
denning93515173d__enning
denting94422183d__enting
denying123711293d__enying
deperming1537113deperming
deponing121211213depon_ing
deposing12129773de_posing
depressing1448093depressing
deranging1238063deranging
desanding12207653desanding
descending1546113descending
deserting11713143deserting
deserving1497903deserving
desexing1736293dese_xing
despising13167503despising
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
devising133111523de_vising
dezincing2244183dezincing
diffusing1743853diffusing
diseasing11310833diseasing
dispensing1448233dispensing
dizening19177143dizen_ing
dovening13238353doven_ing
dozening19236183dozen_ing
dressing102810423d_ressing
effusing1534263_effusing
emending12298893_emending
evening11310223_even_ing
evensong1242653_evensong
expensing1946003expensing
feasing113916653__feasing
fencing132411133__fencing
fending123717603__fending
fessing113812863__fessing
flensing1246973_flensing
incensing1297663incensing
keening123713153ke_en_ing
lensing84015103__lensing
licensing1244753licensing
mensing103915103__mensing
offending1744093offending
peening103318303pe_en_ing
recessing12611013recessing
redenying1437783redenying
refecting152413353refecting
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
referring1338033referring
refinding14259943refinding
refining122416863refin_ing
refunding14258073refunding
refusing122310873ref_using
releasing10411013releasing
relending112412023relending
relenting102716773relenting
remending132311313remending
repenting122316553repenting
rerenting102617663rerenting
resending112313363resending
resenting102619293resenting
revenging1438083revenging
reversing132611483reversing
sensing84116953__sensing
tensing84616653__tensing
unfencing1545953unfencing
weening114113973we_en_ing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411486.26623721.8
3Display Results1481480.0602466.7
 (SQL Overall)1786911486.76226425.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.