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

271 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
ulcered103797(None) 
altered83215742altered
cered85227442__cered
fleered11309502fleered
fullered1236382fullered
leered73816222_leered
ulcer7310752ulcer__
ulcerated1247742ulcerated
ulcers839382ulcer_s
umbered121510112umbered
unceded11410562unceded
uncured10513232uncured
ushered1139152ushered
uttered82712432uttered
acceded1336103acceded
acred87126353_ac_red
adhered1239233adhered
alcoved1375623alcoved
alerted82512223al_erted
aliened81011743aliened
alleged9389323alleged
allured8299173allured
alterer72714003alterer
angered93013473angered
ascared10399523ascared
bickered17108003bickered
blared95018243bl_ared
blazered2035063blazered
bleared104211253bleared
bleed85019803bl_e_ed
bleeped12287273bleeped
blurred10427803blurred
bouldered1344483bouldered
bowered133113043bowered
buffered1764993buffered
buggered1335623buggered
bulleted1138393bulleted
bumpered1536003bumpered
bunkered15177183bunkered
butchered1744583butchered
buttered112712623buttered
cancered132411553cancered
capered123014043capered
cared86050093__cared
catered103117773catered
ceded96118563__ceded
cere66741473__cere_
ceres75540013__ceres
cheered133713293cheered
clavered14187633clavered
cleared103612463cleared
cleeked14357733cleeked
cleped115114113cl_eped
clerid9312413cl_erid
clerked14326653cl_erked
clewed1225113203cl_ewed
cloured103111543cloured
clovered14187363clovered
cockered17710213cockered
cohered133514693cohered
cored85044223__cored
covered133315293covered
cowered133214653cowered
cred76530883__c_red
creed85727393__creed
cultured1137233cultured
cumbered15157963cumbered
cured85932133__cured
dackered16116893dackered
decerned1237263decerned
decreed112710253decreed
dickered16117533dickered
dowered122811553dowered
elected102812613elected
emceed1136283emce_ed
encored10412103encored
entered82718883entered
euchred13106163euchred
exceed1636173exce_ed
faceted13509563faceted
faltered122810993faltered
fevered14339723fevered
fibered1337643fibered
filtered12259043filtered
flared105317603fl_ared
flecked17358073flecked
fleeced13358153fleeced
fleeted113310233fleeted
flexed17419093fl_exed
fleyed13408813fl_eyed
flickered1943753flickered
floored11268683floored
floured11289873floured
flowered1546013flowered
glaceed1136203glace_ed
glaciered1343883glaciered
glaired9387753glaired
glared84715203gl_ared
gleed75320573gl_e_ed
gleeked13346333gleeked
gleeted9379323gleeted
gleyed11478153gl_eyed
glowered1345753glowered
guttered10259163guttered
haltered123112563haltered
havered144011453havered
hollered1237603hollered
homered133212713homered
hovered143411573hovered
hungered13217053hungered
hunkered16186923hunkered
inhered11313163inhered
jeered143912793_jeered
juddered1833583juddered
lackered15108683lackered
lagered92311153lagered
laired75216813_laired
layered11259413layered
leched123716003_leched
lechered1437523lechered
levered114212303levered
livered113111633livered
loured74617403_loured
lowered112711913lowered
lucern846103lucer_n
lucerne945753lucerne
lucernes1046363lucernes
lucerns935753lucerns
lucked135118023luc_ked
lucre76415523luc_re_
lucres84513303luc_res
lumbered13188233lumbered
lured65427493_l_ured
lustered92510603lustered
lustred8359053lustred
metered103514013metered
mitered103213233mitered
moldered1237173moldered
mouldered1343753mouldered
mulched15307763mulc_hed
mulcted12296693mulc_ted
murdered1236023murdered
mustered112511503mustered
muttered112610793muttered
nacred95212493nac_red
nickered15117023nickered
numbered13147143numbered
ochered132610283ochered
ochred12328003_ochred
offered1436143offered
ordered9108533ordered
osiered837123osiered
overed102216623_overed
paltered113012493paltered
papered122513173papered
peered93819493_peered
peltered112510453peltered
petered103314973petered
pilfered1435853pilfered
powered132911643powered
puckered1736103puckered
puttered112611143puttered
quavered2144813quavered
queered17117213queered
quivered2144823quivered
racemed1237013racemed
receded112713043receded
revered112819333revered
rogered939553rogered
rubbered1335383rubbered
sabered103213023sabered
sacred94917103sac_red
scared95227293_scared
sclereid1145363sclereid
scored94621133_scored
screed95718933_screed
seceded11319203seceded
secerned1136103secerned
secured1059723secured
sered65737293__sered
severed113513863severed
sewered112911243sewered
sheered113515453sheered
silvered12237563silvered
slavered12188033slavered
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
slewed104815523sl_ewed
slivered12218103slivered
slurred8359193slurred
sneered83113973sneered
sobered102912433sobered
soldered1038153soldered
speered103614813speered
sphered133512313sphered
spiered104412463spiered
steered83615253steered
succeed1235983succe_ed
succored13135173succored
suckered1537833suckered
suffered1536733suffered
sulcated11310373sulcated
sulfured1236113sulfured
summered1338143summered
sundered10312153sundered
supered10316123supered
tabered103311593tabered
tapered102612933tapered
telfered1234883telfered
tiered73613973_tiered
tillered937443tillered
tochered1437913tochered
towered112911403towered
tuckered1535963tuckered
ulcerate1039733ulcerate
ulcerates1148853ulcerates
ulcering1139333ulcering
ulcerous1046163ulcerous
ullaged937033ullaged
ultrared936663ultrared
umbeled12208193umbeled
umpired1235783umpired
unaired82916013unaired
unaltered1037723unaltered
unbeared111611653unbeared
unbred92613303u_nbred
uncaged113314123uncaged
uncaked143514353uncaked
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncased104216953uncased
uncatered1237403uncatered
unchewed1735803unchewed
uncleared1237543uncleared
uncoded11312743uncoded
uncoerced1445313uncoerced
uncorked152210403uncorked
uncovered1546613uncovered
uncrewed1456763uncrewed
uncurbed1346903uncurbed
uncurled1168963uncurled
uncursed1148973uncursed
underfed13311713underfed
unfeared121511013unfeared
unfired112212453unfired
unfreed11510123unfreed
unhired112512153unhired
unmewed13258173unmewed
unnerved1248063unnerved
unseared91113943unseared
unserved12410233unserved
unsewed112911023unsewed
unsexed152410253unsexed
untired82316383untired
unversed122310433unversed
unvexed18147103unvexed
upcurled1393783upcurled
upcurved16142993upcurved
upreared1137073upreared
utterer71910463utterer
veered103612743_veered
wafered14288433wafered
wagered12299333wagered
watered113014953watered
wavered142910433wavered
weltered12238433weltered
wildered1336633wildered
wuthered15157433wuthered
ycleped1543393ycleped

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 Filter1786911340270.453394461.4
2DLD Change Limit1340272717.42318055.6
3Display Results2712710.1102463.6
 (SQL Overall)1786912717.98622375.5
 
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.