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

226 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
ambush133611(None) 
abash106016512a_bash
ablush1147222ablush
abuse77119562a_buse
ambos95321252ambos_
ambushed1644462ambushed
ambusher1544112ambusher
ambushes1535802ambushes
amus65529612am_us_
amuse75920832am_use
ankush13114432ankush
bush96630712__bush
hagbush1642622hagbush
iambus10468902iambus_
maybush1742452maybush
mush94929122_m_ush
smush104410582sm_ush
tarbush1234172tarbush
abas68642083a_bas_
abase76023483a_base
abbas95918643abbas_
abbes96723523abbes_
abbess10509773abbess
abos67734413a_bos_
abs59356073a_b_s_
abused95614273a_bused
abuser85413683a_buser
abuses85119103a_buses
abut66834953a_bu_t
abuts75417073a_buts
abuzz15517213a_buzz
abys97221883a_bys_
abysm12598143a_bysm
abyss10669463a_byss
accuse103411033accuse
adjust1447183adjust
adust64117453a_dust
afresh1255503afresh
aguish1059283aguish
airbrush1342343airbrush
airbus848343airbus_
albas75925393albas_
albs68628573alb_s_
album92312653albu_m
albums10198273albums
amah98927493am__ah
amahs107819063amahs_
amas67746293am_as_
amass77119683am_ass
ambage11510603ambage
ambari103012173ambari
ambary134010543ambary
ambeer104511603ambeer
amber94523213amb_er
ambers104519583ambers
ambery133811133ambery
ambit94223713amb_it
ambits103713413ambits
amble95924643amb_le
ambled115116373ambled
ambler104916453ambler
ambles105121863ambles
ambo88225143amb__o
ambry123512103amb_ry
ambushers1643433ambushers
ambushing1744033ambushing
amebas10311453amebas_
amens75624843amens_
amias75831473amias_
amicus103810003amicus_
amids85627513amids_
amidst94913233amidst
amies76837693amies_
amins75534323amins_
amirs75924923amirs_
amis66445323am_is_
amiss75823073am_iss
ammos94815823ammos_
amoks11413553amoks_
amount8414483amount
amour75014853amou_r
amours83512663amours
amps86230343am_ps_
ampul91110853ampu_l
ampule10710613ampule
ampuls1098893ampuls
amu58237323am_u__
amuck1389563am_uck
amused94412513am_used
amuser84712623am_user
amuses85117943am_uses
amusia839173am_usia
amyls104512693amyls_
anguish11117633anguish
ankus91410683ankus_
anus47131113a_nus_
apish105116633a_pish
arbs66834733arb_s_
arbute8311043arbute
arcus76918863arcus_
argus66716543argus_
arouse65019983arouse
ascus75013583ascus_
ash67944603a___sh
aslosh966233aslosh
aspish114810333aspish
auburn836213auburn
august739203august
avouch1434833avouch
awash116613163a_wash
awmous1157713awmous_
babus95620333babus_
bash915240163__bash
blush105115313_blush
bosh96328973__bosh
brush105917473_brush
bubus95115453bubus_
bus56950973__bus_
bushy135416683__bushy
busk105429223__busk
buss65134913__buss
bust65947783__bust
busy94727173__busy
cambism1538033cambism
cambist13312113cambist
campus125213923campus_
choush14549063choush
combust1338363combust
crush106815993_crush
dampish1567663dampish
embosk1464863embosk
emboss1087383emboss
emdash12244113emdash
emeus76913333emeus_
emus66821683em_us_
famish14311843fam_ish
famous11412393famous_
flush115116073_flush
gambas115817513gambas_
gambes116318313gambes_
gambs105721123gamb_s_
gambusia1343573gambusia
gush85424003__gush
habus106317143habus_
hamburg1544133hamburg
hush105224113__hush
iambs95815063iamb_s_
iambuses1235783iambuses
imbue939483imbu_e
imbued1136173imbued
imbues1037983imbues
immesh1334113immesh
impish13499193impish
inrush936513inrush
jambes175914053jambes_
jambs166014623jamb_s_
kibosh1534263kibosh
kombus1435523kombus_
kybosh1842713kybosh
lambast11129893lambast
lambs95921413lamb_s_
limbus105710383limbus_
lush75327693__lush
mabes96331533mabes_
magus85318753magus_
mambas125716243mambas_
mambos125414493mambos_
manus75924933manus_
marish114319053marish
marsh105320853_marsh
mash96039403_m_ash
mensh105413563_mensh
mesh96823003_m_esh
mosh95227603_m_osh
mouch124715803_mouch
mouse77133003_mouse
mousy106716943_mousy
mouth105420293_mouth
much115224033_m_uch
mus55946753_m_us_
muse67136033_m_use
mushy135316633_m_ushy
musk104526193_m_usk
muss64933763_m_uss
must65145443_m_ust
musth105314783_m_usth
nimbus10377283nimbus_
onrush935343onrush
plush105614713_plush
push95526623__push
qurush1835503qurush
rammish1437563rammish
ramous8417113ramous_
ramus76418283ram_us_
rebus75721113rebus_
robust8310433robust
rubus76415063rubus_
rush76628183__rush
saltbush1342133saltbush
sambas104219263sambas_
sambos104315193sambos_
sambuca1344343sambuca
sambuke1544203sambuke
sambur10469503sambu_r
samburs11369343samburs
shadbush1741973shadbush
shush113812543_shush
slush85316573_slush
smash104814433sm_ash
smoosh11236733smoosh
squush1833993squush
tabus74820923tabus_
tambur10358713tambu_r
tambura11326463tambura
tamburs11288613tamburs
thrush12257483thrush
tush74523903__tush
umbos94613073umbos_
unbusy1135213unbusy
uprush1135783uprush
vampish1766283vampish
wammus13426733wammus_
wampish1777293wampish
wampus13499013wampus_
wamus105514683wam_us_
zebus164610053zebus_

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162264.97022679.3
3Display Results2262260.0802825.0
 (SQL Overall)1786912265.45632751.3
 
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.