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

245 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
ulcering113933(None) 
altering91917112altering
cering94522532__cering
fleering123811282fleering
fullering1336652fullering
leering83417642_leering
ulcerating1346982ulcerating
umbering1399432umbering
uncaring11312842uncaring
ushering1258922ushering
uttering91613082uttering
acceding1446093acceding
adhering1338883adhering
alerting91312383al_erting
algerine9810283algerine
aliening91510893aliening
alleging1038473alleging
alluring939073alluring
angering102113803angering
bickering1837663bickering
blaring104317113bl_aring
blearing113111943blearing
bleeding12359053bleeding
bleeping13377933bleeping
blueing103710203blue_ing
blurring11277233blurring
bouldering1464763bouldering
bowering142911713bowering
buffering1835223buffering
buggering1435193buggering
bulleting1236643bulleting
bullring11388423bul_lring
bumpering1636593bumpering
bunkering16207103bunkering
butchering1844503butchering
buttering122312523buttering
capering132414963capering
caring95137993__caring
catering112019903catering
ceding104014803__ceding
cheering143612703cheering
clavering1538373clavering
clearing113014883clearing
cleeking15267813cleeking
cleping123310423cl_eping
clerking15257163cl_erking
clewing13359583cl_ewing
clouring112811273clouring
clueing104110093clue_ing
cockering1839693cockering
cohering142413833cohering
coring94433963__coring
covering142215723covering
cowering142514033cowering
culturing1236553culturing
culverin1345173culverin_
culverins1445373culverins
cumbering16108203cumbering
curing94824783__curing
dackering1737383dackering
decerning1337293decerning
dickering1737463dickering
dowering132510613dowering
electing112113783electing
emceeing1343573emceeing
encoring11312173encoring
entering91920053entering
euchring1436613euchring
faceting1438783faceting
faltering132211113faltering
fevering152510083fevering
filtering13199723filtering
flaring114116803fl_aring
flecking18408233flecking
fleecing14347573fleecing
fleeing113511293fl_eeing
fleeting122910323fleeting
flexing18358993fl_exing
fleying14329873fl_eying
flickering2044093flickering
flooring12259883flooring
flouring123010143flouring
flowering1636053flowering
glaceing1236533glace_ing
glairing1047283glairing
glaring93714883gl_aring
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gl_eying
glowering1435653glowering
glueing9338713glue_ing
glycerin1444353glycerin_
glycerine1544703glycerine
glycerins1544553glycerins
guttering112410443guttering
haltering132212003haltering
havering152211053havering
hollering1337743hollering
homering141512073homering
hovering151911143hovering
hungering14187683hungering
hunkering17227123hunkering
inhering12913713inhering
jeering153513043_jeering
juddering1933763juddering
lacewing1435843lacewing
lackering1639373lackering
lagering102212313lagering
lairing83715343_lairing
layering122310353layering
lechering1538443lechering
leching134613653_leching
levering122212503levering
livering122012383livering
louring83916503_louring
lowering122210913lowering
lucern846103lucer_n_
lucerne945753lucer_ne
lucerns935753lucer_ns
lucking143615833luc_king
lugeing9359113luge_ing
lumbering14117933lumbering
luring73820753_l_uring
lustering102711203lustering
lustring9269723lustring
metering112915633metering
mitering113015403mitering
moldering1367863moldering
mouldering1474283mouldering
mulching16287103mulc_hing
mulcting13246983mulc_ting
murdering1357133murdering
mustering122212333mustering
muttering122611323muttering
nickering1636573nickering
nidering10510483nidering
numbering14107003numbering
ochering14219393ochering
ochring13156673_ochring
offering1536393offering
ordering1039353ordering
overing111918053_overing
paltering122612893paltering
papering132213313papering
peering103520353_peering
peltering122011673peltering
petering112516813petering
pilfering1536393pilfering
powering142210803powering
puckering1835883puckering
puttering122611643puttering
quavering2235953quavering
queering1838203queering
quivering2235873quivering
receding122713763receding
revering122918073revering
rogering10310273rogering
rubbering1435703rubbering
sabering112113743sabering
sacring103115983sac_ring
scaring103421973_scaring
scoring103117213_scoring
seceding12288563seceding
secerning1246203secerning
securing11310413securing
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
silvering1337923silvering
slavering1338723slavering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sl_ewing
slivering1338083slivering
slurring9288833slurring
sneering93414503sneering
sobering111912783sobering
soldering1169033soldering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
steering93916793steering
succoring1445873succoring
suckering1638103suckering
suffering1637293suffering
sulfuring1345783sulfuring
summering1458753summering
sundering11312323sundering
supering11317683supering
tabering112211423tabering
tapering112112503tapering
telfering1336253telfering
tiering8315253_tiering
tillering1037883tillering
tochering1537153tochering
towering122610873towering
tuckering1635693tuckering
ulcer7310753ulcer___
ulcerate1039733ulcerate
ulcered1037973ulcer_ed
ulcerous1046163ulcerous
ulcers839383ulcer__s
ulterior845443ulterior
umpiring1336093umpiring
unbearing1239353unbearing
unbeing1039373unbe_ing
uncaging1268713uncaging
uncaking1539463uncaking
uncasing11511003uncasing
unceasing1239653unceasing
uncorking1637403uncorking
uncovering1645293uncovering
uncurbing1455513uncurbing
uncurling1237113uncurling
undaring10412753undaring
underling111514613underling
underwing141410883underwing
unerring9311273unerring
unfearing1338883unfearing
unmewing1485913unmewing
unnerving1336633unnerving
unseeing988293unseeing
unsewing1287433unsewing
unsexing1686853unsexing
unstring9312093unstring
untiring9312003untiring
upbearing1435033upbearing
upcoming1535173upcoming
upcurling1453493upcurling
upcurving1742563upcurving
uprearing1238373uprearing
upspring1335703upspring
uptearing1236103uptearing
uterine7315193u_terine
veering113213683_veering
wafering15208893wafering
wagering13219523wagering
watering122316313watering
wavering152410543wavering
weltering13219493weltering
wildering1456743wildering
wuthering1697803wuthering

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622456.84321359.3
3Display Results2452450.1102227.3
 (SQL Overall)1786912457.38924183.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.