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

313 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
ushering125892(None) 
adhering1338882adhering
ashlering1344152ashlering
busheling1535502busheling
cohering142413842cohering
coshering15510022coshering
inhering12913712inhering
kashering1736252kashering
koshering1735362koshering
lustering102711202lustering
mustering122212332mustering
ochering14219392ochering
sering74731812_s_ering
sharing113723242_sharing
shearing123915902_shearing
sheering123715102_sheering
shewing143812192_shewing
shoring112820072_shoring
sphering142811942sphering
supering11317682supering
ulcering1139332ulcering
umbering1399432umbering
unsphering1644282unsphering
uttering91613082uttering
wuthering1697802wuthering
altering91917123altering
angering102113803angering
answering1345803answering
ashing107824093ash__ing
ashlaring1344493ashlaring
aspersing1237603aspersing
aspiring1138873aspiring
asserting1038663asserting
assuring937773assuring
atheling1249203atheling
authoring1348583authoring
blustering13106183blustering
bothering152210203bothering
bowering142911713bowering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
bushelling1644063bushelling
bushing134018583bush__ing
butchering1844503butchering
buttering122312533buttering
capering132414963capering
cashiering1643783cashiering
catering112019913catering
cering94522533__cering
charing133721323_charing
cheering143612703cheering
chefing16359033_chefing
chewing163911143_chewing
choring133617663_choring
ciphering17217703ciphering
clustering13116813clustering
covering142215733covering
cowering142514043cowering
cumbering16108203cumbering
cyphering20175243cyphering
dithering1499853dithering
dowering132510613dowering
ensphering1644973ensphering
entering91920053entering
eschewing1893503eschewing
eserine7415903es_erine
euchring1436613euch_ring
fathering161010093fathering
festering132413173festering
fevering152510083fevering
fleering123811283fleering
flustering14105933flustering
fostering132411263fostering
fullering1336653fullering
furthering1744353furthering
gathering1499463gathering
gushing124014223gush__ing
gusseting1173963gusseting
guttering112410443guttering
haring104233003__haring
havering152211053havering
hearing113324163__hearing
heiring113312903__heiring
herding122915123__herding
herring113615883__herring
hewing134514243__hewing
hexing174210513__hexing
hiring104421603__hiring
homering141512073homering
hovering151911143hovering
hungering14187683hungering
hunkering17227123hunkering
hushing144514473hush__ing
insphering1644193insphering
jeering153513043_jeering
juddering1933763juddering
lagering102212313lagering
lathering13912253lathering
layering122310353layering
lechering1538443lechering
leering83417643_leering
levering122212503levering
livering122012383livering
lowering122210913lowering
lumbering14117933lumbering
lushing114316113lush__ing
lustring9269723lus_tring
mastering122315313mastering
metering112915633metering
mishearing1647883mishearing
mitering113015403mitering
mothering152110183mothering
murdering1357133murdering
murthering1644473murthering
mushing134217633mush__ing
muttering122611323muttering
nidering10510483nidering
numbering14107003numbering
ochring13156673och_ring
offering1536393offering
ordering1039353ordering
outhearing1438443outhearing
overing111918053_overing
oystering1337563oystering
papering132213313papering
peering103520353_peering
pestering122315663pestering
petering112516813petering
pothering151911283pothering
powering142210803powering
pshawing1733523pshawing
puckering1835883puckering
pushing133615453push__ing
puttering122611643puttering
quavering2235953quavering
queering1838203queering
quivering2235873quivering
rehearing132211763rehearing
rehiring122911883rehiring
revering122918073revering
rogering10310273rogering
rubbering1435703rubbering
rushing113817703rush__ing
russeting1065323russeting
sabering112113743sabering
sabring102614843_sabring
sacring103115983_sacring
scaring103421973_scaring
scheming1636633scheming
scoring103117213_scoring
searing83330923_searing
seeding93719483_seeding
seeing74222143_s_eeing
seeking124016063_seeking
seeling83522003_seeling
seeming103216263_seeming
seeping103817913_seeping
serging93416673_s_erging
serin55434443_s_erin_
serine65432673_s_erine
seringa83310743_s_eringa
serins64029673_s_erins
serving113014983_s_erving
severing122013853severing
sewering122411093sewering
sewing103819623_s_ewing
sexing144313893_s_exing
shading123115563_shading
shaking153317253_shaking
shaming133016743_shaming
shaping133116183_shaping
sharking163912973_sharking
sharping143011373_sharping
shaving143414333_shaving
shawing143514883_shawing
sheafing15329483_sheafing
shealing123415463_shealing
shearings13337563_shearings
shearling1336923_shearling
sheaving154110253_sheaving
shebang1334843_shebang
shedding14278113_shedding
sheening123010803_sheening
sheeting122712833_sheeting
shelling123515213_shelling
shelving15278173_shelving
shending132511253_shending
sherif122915243_sheri_f
sheriff16287693_sheriff
sherifs13299683_sherifs
shieling123512403_shieling
shining113816523_shining
shirking163210473_shirking
shirring122910443_shirring
shirting123213613_shirting
shivering1637333_shivering
shoeing113211883_shoeing
shooing112112913_shooing
shorings12269483_shorings
shorting122514803_shorting
shoving142910643_shoving
showering1646403_showering
showing143814663_showing
showring1548323_showring
shrewing15228093_shrewing
shrine94920053_sh_rine
shrink134511733_sh_rink
shuting113212053_shuting
shying134211843_sh_ying
sieging92613203_sieging
sieving112311233_sieving
siring75128313_s_iring
sistering101213753sistering
skeeing12308853_skeeing
skewing15318723_skewing
slewing113311353_slewing
smearing113511753_smearing
smerking15258473_smerking
snaring83920953_snaring
sneering93414503sneering
snoring83917203_snoring
soaring83521893_soaring
sobering111912783sobering
soring74731883_s_oring
souring83219063_souring
sparing104823873_sparing
spearing113216103_spearing
speering113116323speering
speiring113711263_speiring
spewing133110453_spewing
spiering112713353spiering
spiring103918183_spiring
sporing104319413_sporing
spring94526013_s_pring
staring84527053_staring
steering93916793steering
sterling93615553_sterling
stewing113412493_stewing
storing83921123_storing
string75327563_s_tring
suberin9314563suberin_
suberins10315093suberins
subring104116263_subring
suckering1638103suckering
sueding92613753_sueding
suffering1637293suffering
sugaring1039053sugaring
summering1458753summering
sundering11312323sundering
suspiring1245703suspiring
suturing9310373suturing
swearing123711443_swearing
swerving1546113_swerving
syphering18175733syphering
tabering112211423tabering
tapering112112503tapering
tethering1339133tethering
theming133610473_theming
tiering8315253_tiering
tochering1537153tochering
towering122610873towering
tuckering1635693tuckering
tusheries1246893tusheries
tushing114214013tush__ing
umpiring1336093umpiring
unbearing1239353unbearing
unbeing1039373unbe_ing
uncaring11312843uncaring
undaring10412753undaring
underling111514613underling
underwing141410883underwing
unerring9311273unerring
unfearing1338883unfearing
unhairing1335953unhairing
unheeding1446103unheeding
unhelming1535493unhelming
unhorsing1336853unhorsing
unmewing1485913unmewing
unnerving1336633unnerving
unseeing988293unseeing
unsewing1287433unsewing
unsexing1686853unsexing
unshelling1445593unshelling
unsparing1237713unsparing
unstring9312093unstring
unswearing1444413unswearing
unswerving1743043unswerving
untiring9312003untiring
upbearing1435033upbearing
upheaping1743853upheaping
upheaving1843803upheaving
uprearing1238373uprearing
upsoaring1244513upsoaring
upspring1335703upspring
upstaring1235963upstaring
uptearing1236103uptearing
usher84517763usher___
ushered1139153usher_ed
ushers94415533usher__s
using66317963us___ing
usurping1134163usurping
uterine7315193u_terine
veering113213683_veering
vouchering1943653vouchering
wafering15208893wafering
wagering13219523wagering
watering122316323watering
wavering152410543wavering
westering132112643westering
whoring142910293_whoring
withering16108813withering

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 Limit1461623137.08020644.4
3Display Results3133130.1402235.7
 (SQL Overall)1786913137.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.