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

127 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
ambushes153580(None) 
ambushed1644461ambushed
ambusher1544111ambusher
ambushers1643431ambushers
abashes12510372a_bashes
abuses85119102a_bus_es
ambush1336112ambush__
amuses85117942am_us_es
ankushes1544582ankushes
bushes115226112__bushes
hagbushes1842562hagbushes
iambuses1235782iambus_es
maybushes1942442maybushes
mushes114124562_m_ushes
smushes123710092sm_ushes
tarbushes1444882tarbushes
abases85720773a_bas_es
abashed1357663a_bashed
abbesses1235333abbesses
abuse77119563a_bus_e_
abused95614273a_bus_ed
abuser85413683a_bus_er
abusers94710553a_busers
abysses1234863a_bysses
accuses114112193accus_es
airbrushes1552173airbrushes
airbuses1067073airbus_es
airbusses1153613airbusses
amasses93912853am_asses
ambages1269623amb_ages
ambaries123312383ambaries
amberies122514683amberies
ambles105121863amb__les
ambones11312683amb_ones
ambries111614553amb_ries
ambsaces1455213ambsaces
ambulates1348383ambulates
ambuscades1752273ambuscades
ambushing1744033ambushing
ambushment1964443ambushment
ambushments2063693ambushments
ampules1189433ampu_les
amputees1245103amputees
amuse75920833am_us_e_
amused94412513am_us_ed
amuser84712623am_us_er
amusers94610193am_users
amusias938583am_usias
anguishes1345093anguishes
ankuses1148203ankus_es
anuses66218773a_nus_es
arbuscles1342813arbuscles
arbutes939703arbu_tes
arcuses94814693arcus_es
arguses84711743argus_es
arouses74921293arous_es
ashes86230613a___shes
avouches1634823avouches
bashes115631393__bashes
blushes124314823_blushes
boshes114721883__boshes
brushes124014663_brushes
buses75936013__bus_es
bushed124822383__bushed
bushel114513943__bushel
bushels124110713__bushels
busher114922203__busher
bushers124018803__bushers
busies85525263__busies
busses85023383__busses
campuses1437773campus_es
choushes1637623choushes
crushes124215133_crushes
embosses1235963embosses
emdashes14224303emdashes
famishes1658283fam_ishes
flushes134114143_flushes
gamashes1456953gam_ashes
gambusias1443343gambusias
gushes104719033__gushes
hushes124718593__hushes
imbues1037983imbu__es
immeshes1543933immeshes
inrushes1136273inrushes
kiboshes1744013kiboshes
kyboshes2042743kyboshes
lambastes13114693lambastes
limbuses1234903limbus_es
lushes94022743__lushes
marishes13512553marishes
marshes123615373_marshes
mashes115030003_m_ashes
menshes12310453_menshes
meshes115019443_m_eshes
moshes115222873_m_oshes
mouches143815963_mouches
mouses85531423_mous_es
mousses94012703_mousses
muches134718993_m_uches
muses75134303_m_us_es
mushed124420843_m_ushed
musher113820573_m_usher
mushers124016443_m_ushers
musses84624783_m_usses
nimbuses1244663nimbus_es
onrushes1135213onrushes
plushes124313673_plushes
pushes114621663__pushes
qurushes2034943qurushes
rebuses94915293rebus_es
rushes94724363__rushes
saltbushes1542173saltbushes
sambukes1644193sambu_kes
shadbushes1951813shadbushes
shushes133510303_shushes
slushes103514413_slushes
smashes123914613sm_ashes
smooshes13206863smooshes
smushed13368233sm_ushed
squushes20194673squushes
thrushes1436523thrushes
tushes94319473__tushes
uprushes13194863uprushes
wammuses1543493wammus_es
wampishes1944303wampishes
wampuses1534113wampus_es
wamuses1237023wam_us_es

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 Limit1461621277.56319325.9
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.03222247.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.