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 “ushers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
ushers9441553(None) 
bushers124018801bushers
gushers113512511gushers
mushers124016441mushers
pushers123814501pushers
rushers103816101rushers
users55817571us_ers
usher84517761usher_
ashes86230612ashe_s
ashlers10319582ashlers
askers105915402askers
aspers86220312aspers
asters65631602asters
bashers124820832bashers
blushers133911292blushers
brushers134210572brushers
bushels124110712bushels
busher114922202busher_
bushes115226112bushe_s
buskers133414092buskers
busters94724132busters
coshers123618182coshers
crushers134010092crushers
cussers94213402cussers
dashers115016862dashers
dusters84918362dusters
eskers105312222eskers
esters64627732esters
ethers94518412ethers
fishers134714722fishers
flushers14279732flushers
fussers104210812fussers
gusher104115772gusher_
gushes104719032gushe_s
hers75844872__hers
hushes124718592hushe_s
huskers143510042huskers
joshers174111592joshers
justers143815732justers
kashers143914022kashers
koshers144811802koshers
lashers104121832lashers
lusher93818762lusher_
lushes94022742lushe_s
lusters73921442lusters
mashers124621052mashers
moshers124017842moshers
musers84719102mus_ers
musher113820572musher_
mushes114124562mushe_s
musters94522512musters
noshers103614332noshers
ochers113915302ochers
osiers63412792osiers
others93918002others
ousters74122792ousters
pishers123815752pishers
pusher114318282pusher_
pushes114621662pushe_s
quashers20186802quashers
rashers104020912rashers
rushees103311952rushees
rusher94019652rusher_
rushes94724362rushe_s
seers55136382_seers
sers45746652_s_ers
shears93820902_shears
sheas86331792_sheas
sheds96122702_sheds
sheers94322402_sheers
sherd96321152_sherd
sherds105614722_sherds
shes75734352_she_s
shews115924712_shews
shiers94921752_shiers
shoers94518332_shoers
shushers14267052shushers
shyers124712202_shyers
subers85722642subers
suers55128482_suers
supers84622402supers
tushery1335632tushery
tushes94319472tushe_s
tuskers113710042tuskers
tussers74313562tussers
udders83911292udders
ulcers839382ulcers
ulsters72711982ulsters
umbers104215212umbers
uppers102912292uppers
urgers73313622urgers
user45023002us_er_
uses44931112us_e_s
ushered1139152ushered
usneas638332usneas
usurers766362usurers
utters63817122utters
washers134517522washers
wishers133215212wishers
wuthers133711522wuthers

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511002.36034979.2
3Display Results1001000.0303333.3
 (SQL Overall)1786911002.73365382.7
 
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.