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

132 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
ascender113673(None) 
ascended1246511ascended
ascenders1235681ascenders
absconder1443012absconder
acceder1235362acce_der
amender10349612a_mender
ascend9429732ascend__
ascendent1245942ascendent
ascends10388202ascend_s
assenter867702assenter
asunder856222as_under
attender935912attender
descender1346662descender
scended11329872_scended
sender73824412_s_ender
slender83413592_slender
spender103713692_spender
absconded1543003absconded
absconders1542373absconders
absenter1086773absenter
accede1138303acce_de_
acceded1336103acce_ded
acceders1334793acce_ders
accedes1237723acce_des
accented13107773accented
accentor12106133accentor
accepter14144933accepter
accorder1395253accorder
acerber1135243a_cerber
acrider1038623a_crider
aliener71011193alien_er
amended11328313a_mended
amenders11288353a_menders
ancienter1145393ancienter
appended1435483appended
ascendant1245163ascendant
ascendence1594663ascendence
ascendency18123423ascendency
ascendents1344243ascendents
ascending1336283ascending
ascent84519653ascen__t
ascents93812553ascen_ts
asceses938623asce_ses
asperser10408303asperser
assented957513assented
assenters966993assenters
assentor865293assentor
asserter877573asserter
attended1035763attended
attendee946403attendee
attenders1045273attenders
auslander1043883auslander
avenger1135493a_venger
bartender1244603bartender
bender95223303__bender
blender104613843_blender
calender1138273calender
ceder85322243__ce_der
censer84516583__censer
center84421413__center
cinder94119123__cinder
decenter112412163decenter
defender1337293defender
degender1136893degender
descended1446283descended
descenders1445453descenders
distender11167743distender
emender10649843_emender
ender64325863___ender
engender1046633engender
exceeder1843953exceeder
expender18136843expender
extender16146333extender
fastener11227833fasten_er
fender103718723__fender
gasconader1452183gasconader
gender83517933__gender
hastener11259133hasten_er
incenter102212093incenter
intender93310443intender
islander946103islander
larcener1036493larcen_er
lavender1235143lavender
lender73921273__lender
licencer12146133licencer
licenser10155883licenser
mender93520793__mender
misrender1286293misrender
nascence1256183nascence_
nascences1346233nascences
obscener1244323obscen_er
offender1543723offender
parcener1238473parcen_er
passenger1243413passenger
reascended1444363reascended
recenter102715443recenter
render74024143__render
rescinder1245293rescinder
sander74828533_s_ander
scanner94411813_scanner
scanter94215183_scanter
scend85516293_scend__
scends95213003_scend_s
scene77220573_scen_e_
scenery1236563_scen_ery
scenes84520353_scen_es
scented102811883_scented
scepter1138363_scepter
scolder103210343_scolder
scowder13286873_scowder
scunner9358243_scunner
seceder10329573_seceder
seconder1137183seconder
seder64826763_s_e_der
seeder74320773_s_eeder
sended85121233_s_ended
senders83022353_s_enders
shedder12339323_shedder
slander84015443_slander
sledder9399203_sledder
sonder73623523_s_onder
sounder83315383_sounder
speeder103811073_speeder
spencer113610973_spencer
spenders113211743_spenders
spendier1147143_spendier
stander84316163_stander
sunder74019823_s_under
suspender12115093suspender
tailender1044073tailender
tender74121843__tender
vender103418423__vender

Search took 9 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.423422437.4
2DLD Change Limit1461621327.59319249.6
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.07922118.0
 
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.