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

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

95 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
ambushed164446(None) 
ambusher1544111ambusher
ambushes1535801ambushes
abashed1357662a_bashed
abused95614272a_bus_ed
ambush1336112ambush__
ambushers1643432ambushers
amused94412512am_us_ed
bushed124822382__bushed
mushed124420842_m_ushed
smushed13368232sm_ushed
abased96514993a_bas_ed
abashes12510373a_bashes
abuse77119563a_bus_e_
abuser85413683a_bus_er
abuses85119103a_bus_es
abutted1056983a_butted
accused12368423accus_ed
adjusted1743613adjusted
airbrushed1651553airbrushed
airshed11258533a_irshed
amassed10388633am_assed
ambled115116373amb__led
ambulated1457133ambulated
ambuscade1652423ambuscade
ambuscaded1851603ambuscaded
ambushing1744033ambushing
ambushment1964443ambushment
amounted1135533amounted
amuse75920833am_us_e_
amuser84712623am_us_er
amuses85117943am_us_es
anguished1443983anguished
ankushes1544583ankushes
aroused84914343arous_ed
ashed97829773a___shed
avouched1743583avouched
bashed126225703__bashed
blushed134411753_blushed
brushed133811213_brushed
bused85624493__bus_ed
bushel114513943__bushel
busher114922203__busher
bushes115226113__bushes
busied95117223__busied
busked134917703__busked
bussed94717053__bussed
busted95123153__busted
caboshed1634393caboshed
campused1535253campus_ed
combusted1644643combusted
crushed134111963_crushed
embosked1743693embosked
embossed1344693embossed
famished1766023fam_ished
flushed143310973_flushed
gushed114816243__gushed
hagbushes1842563hagbushes
hushed134416673__hushed
iambuses1235783iambus_es
imbued1136173imbu__ed
immeshed1643433immeshed
kiboshed1842763kiboshed
kyboshed2141753kyboshed
lambasted14103253lambasted
lushed104218723__lushed
mashed125325043_m_ashed
maybushes1942443maybushes
meshed124415933_m_eshed
moshed124517493_m_oshed
mouched153612593_mouched
moused94423303_mous_ed
moussed10338913_moussed
mouthed133811043_mouthed
mused85524583_m_us_ed
musher113820573_m_usher
mushes114124563_m_ushes
mussed94418903_m_ussed
musted93321073_m_usted
nimbused1343013nimbus_ed
pushed125017463__pushed
rushed104419863__rushed
shushed14348493_shushed
slushed113611243_slushed
smashed133711223sm_ashed
smooshed14185993smooshed
smushes123710093sm_ushes
squushed21193703squushed
tarbushes1444883tarbushes
tushed104615893__tushed
unbrushed1544433unbrushed
unbusted11258773unbusted
unrushed12247573unrushed
uprushed14234473uprushed
wampished2042803wampished

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.1561145455.1
2DLD Change Limit146162957.00020880.3
3Display Results95950.0332878.8
 (SQL Overall)178691957.18924856.2
 
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.