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

350 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
ambages126962(None) 
ambage11510591ambage_
abases85720772a_bases
abates85825032a_bates
adages8412952a_dages
amazes175613472am_azes
ambaries123312352ambaries
ambaris113112122ambaris
ambles105121852amb_les
ambones11312682ambones
ambries111614532ambries
ambsaces1455212ambsaces
anlages82414102anlages
aubades1038742aubades
cabbages1537202cabbages
cubages1237922cubages
damages11511272dam_ages
gambades1435862gambades
gamboges1435652gamboges
garbages1238182garbages
images91411452im_ages
mages85036022_m_ages
manages103418962manages
rampages1336672rampages
umbrages1336622umbrages
abacas104414723a_bacas
abacus10349763a_bacus
abakas123911743a_bakas
abamps1236253a_bamps
abas68642083a_ba__s
abase76023483a_base_
abased96514993a_based
abaser86414343a_baser
abasers95311973a_basers
abashes12510373a_bashes
abate76627843a_bate_
abated95918453a_bated
abater85518123a_bater
abaters95115193a_baters
abatis84317933a_batis
abayas114011703a_bayas
abbacies1445483abbacies
abbas95918643abba__s
abbes96723523a_b_bes
abeles84719393a_beles
abides94719893a_bides
ablates92416903ablates
ables75935543a_b_les
abodes94417513a_bodes
aboves114512843a_boves
abrades10312073abrades
abuses85119103a_buses
abyes105518533a_b_yes
acreages1138363acreages
adage7414053a_dage_
addaxes1634573addaxes
aerates74627483aerates
agapes95212413a_gapes
agates76121333a_gates
agaves104611513a_gaves
ages55844593___ages
agnates82813183agnates
agrafes1137523agrafes
airbags1036293airbag_s
alates64833963a_lates
albas75925393alba__s
albatas938373albatas
albites9313203albites
alcades101011473alcades
aliases7914493aliases
alkanes113812933alkanes
alleges84212563alleges
almagest1146233almagest
amahs107819063am_a_hs
amas67746293am_a__s
amass77119683am_a_ss
amasses93912853amasses
amaze166016603am_aze_
amazed18519303am_azed
ambagious1443403ambagious
ambari103012153amba_ri
ambary134010533amba_ry
ambeer104511593amb_eer
ambeers11428923ambeers
amber94523203amb__er
amberies122514673amberies
ambers104519563amb_ers
ambiances1545713ambiances
ambits103713393amb_its
amble95924633amb_le_
ambled115116353amb_led
ambler104916443amb_ler
amblers115213563amblers
ambos95321243amb__os
ambsace1355963ambsace_
ambulates1348383ambulates
ambushes1535803ambushes
amebae1049633ameba_e_
amebas10311453ameba__s
amebiases1343723amebiases
amerces1149853amerces
amesaces1246693amesaces
amias75831463amia__s
amices105018013am_ices
amidases1136643amidases
amides95722663am_ides
amies76837683am__ies
amigas95912163am_igas
amigos94511203am_igos
amines84727983am_ines
amirates101114793amirates
amities9317383amities
ammines11312673ammines
amoles84122193am_oles
amperages1447673amperages
amperes11313983amperes
ampules1189433ampules
amuses85117943am_uses
amylases1346653amylases
anabases1038083anabases
anlaces92313733anlaces
anlage72514223anlage_
anlagen8238633anlagen
anlases72514903anlases
annates72415423annates
apanages1137013apanages
arables91814973arables
arames84622573a_rames
arbalest1039523arbalest
arbores94016033arbores
arbutes939703arbutes
arcades101113193arcades
armbands1355143armbands
arranges939413arranges
arrases71214543arrases
assuages936273assuages
asswages1255053asswages
atlases72410643atlases
aubade939223aubade_
auberges1146673auberges
avenges1157543avenges
averages1249183averages
avgases11106313avgases
aviates10313063aviates
awakes135012473a_wakes
babes95834113__babes
badges103917363__badges
bagel85116793__bagel
bagels95712313__bagels
baggages1335443baggages
bags76645503__bag_s
bakes117035373__bakes
bales76250083__bales
bandages12310633bandages
banes74945583__banes
bares75457133__bares
barges94528253__barges
barrages11711083barrages
bases75644353__bases
bates75846343__bates
borages103917163borages
bubales113513343bubales
cabbage1446983cabbage_
cabbaged1644383cabbaged
cabbagey1843213cabbagey
cages85936013__cages
camases114216343cam_ases
carnages11312213carnages
cartages11313313cartages
clambakes1943303clambakes
cowages13310933cowages
cubage1178273cubage_
damage10410773dam_age_
damaged1257453dam_aged
damager1157973dam_ager
damagers1237063dam_agers
debags104211063debag_s
debases103814133debases
debates103718523debates
dosages92310803dosages
dotages92311793dotages
embalms1335333embalms
embanks15295703embanks
embargoes1442903embargoes
embarks15337353embarks
embars103812873emba_rs
embayed1535443embayed
embays131408323emba_ys
emblazes2135673emblazes
embraces14128863embraces
embrues1136473embrues
emerges101310883emerges
empales112411433empales
encages103313783encages
engages92912493engages
enrages83114853enrages
forages114217273forages
gages74529973__gages
gambade1336383gambade_
gambadoes1542823gambadoes
gambados1444143gambados
gambas115817513gamba__s
gambes116318313gamb__es
gambles124016203gamb_les
gamboge1335583gamboge_
garages9314113garages
garbage1138053garbage_
garbagey1543373garbagey
gasbags1135473gasbag_s
gavages1237683gavages
hamates122917673ham_ates
hambones1539673hambones
haulages1236623haulages
haylages1536013haylages
herbages1437083herbages
homages131011583homages
iambuses1235783iambuses
image81411283im_age_
imaged1097753im_aged
imager9108113im_ager
imagers10107753im_agers
imagoes10126403im_agoes
imagos9117543im_agos
imbalms1334543imbalms
imbarks15326603imbarks
imbibes1334673imbibes
imblazes2144723imblazes
imbrues1135493imbrues
imbues1037963imb_ues
impales113311763impales
incages103013883incages
innages82911303innages
jambes175914053jamb__es
lambadas1354873lambadas
lambastes13114693lambastes
lambasts12145623lambasts
lambies113015103lamb_ies
lampases1267293lampases
lavages1138603lavages
linages8813173linages
lovages1138033lovages
lumbagos1343073lumbagos
mabes96331533_m_abes
maces97139963_m_aces
madames12310063madames
maes66948393_m_a_es
mage75739123_m_age_
mags75444523_m_ag_s
magus85318753_m_agus
makes115336853_m_akes
malates93522603malates
males75049793_m_ales
mambas125716243mamba__s
mamboes135011823mamb_oes
manage93818903manage_
managed113212603managed
manager103413583manager
managers112911003managers
maneges103612143maneges
manes76648953_m_anes
manges94628943_manges
mares76457633_m_ares
marges94525713_marges
massages1159883massages
mates75251363_m_ates
maxes145629533_m_axes
mazes165632173_m_azes
meager94515193_meager
menages103615393menages
merges94122483_merges
metages102714973metages
midges103516473_midges
milages103114403milages
mirages102213533mirages
myases113711553_myases
nonages8313843nonages
ohmages13115093ohmages
ombres103911133omb_res
outages82317323outages
packages17138733packages
pages85235073__pages
parbakes1638343parbakes
passages1139513passages
pawnages1435313pawnages
peages94321843_peages
pelages10714613pelages
phages125213513_phages
pipages1289423pipages
plages94520153_plages
potages102416423potages
ragbags1135113ragbag_s
rages64539443__rages
rambles113118313ramb_les
rampage1237453rampage_
rampaged1434103rampaged
rampager1344453rampager
rampagers1443863rampagers
ratbags1035763ratbag_s
ravages1139403ravages
rebates95123173rebates
rivages1138873rivages
rubaces1139303rubaces
rummages1344933rummages
sages65339063__sages
salvages1238123salvages
sambaed1238303samba_ed
sambals115213483samba_ls
sambars115113843samba_rs
sambas104219263samba__s
sambukes1644193sambukes
sausages937003sausages
savages1139973savages
sewages1139753sewages
silages82514443silages
smazes174311663sm_azes
smidges11448193smidges
smudges11348283smudges
socages101012053socages
stages75629493_stages
swages104417073_swages
tallages92312003tallages
tamales93216143tam_ales
tambacs13219363tamba_cs
tambaks15218153tamba_ks
tambalas1237033tambalas
tankages13217113tankages
tannages9228963tannages
timbales12227843timbales
towages1139233towages
triages82613793triages
ullages838953ullages
umbles103817483umb_les
umbones1138013umbones
umbrage1236723umbrage_
unbales92914863unbales
uncages103213773uncages
usages759603_usages
vambraces1843753vambraces
vantages12119023vantages
visages1138693visages
voyages1435703voyages
waftages15105393waftages
wages95330933__wages
wambles143714023wamb_les
wantages12109023wantages
warpages1437053warpages
wastages12109753wastages
wattages12106783wattages
webpages1643053webpages
yardages1336203yardages

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 Filter1786911340270.190940478.9
2DLD Change Limit1340273507.31018334.7
3Display Results3503500.1262777.8
 (SQL Overall)1786913507.62623431.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.