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

396 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
ambones1131268(None) 
hambones1539671hambones
umbones1138011umbones
abodes94417512a_bodes
aboves114512842a_boves
agones75719862a_gones
amarones10311352amarones
ambages1269622ambages
ambles105121862amb_les
amboinas1246032amboinas
ambos95321252ambo__s
amboynas1543232amboynas
ambries111614562ambries
amidones11348662amidones
amines84727982am_ines
ammines11312672ammines
amoles84122192am_oles
ancones93116342ancones
arbores94016032arbores
atones65225772a_tones
axones134614512a_xones
bones76446532__bones
debones103315112debones
gamboges1435652gamboges
hambone1439312hambone_
hamboned1637002hamboned
impones112712252impones
jawbones20134852jawbones
mamboes135011822mambo_es
sawbones13126642sawbones
abalones1038753abalones
abases85720773a_bases
abates85825043a_bates
abbes96723533a_b_bes
abbots1039293abbo_ts
abeles84719393a_beles
abides94719893a_bides
abioses9311503abioses
ables75935543a_b_les
abode85518813a_bode_
aboded104912513a_boded
abohms1335003a_bohms
abomas101113583a_bomas
aborts84916193a_borts
abos67734413a_bo__s
abounds10217083a_bounds
above105414323a_bove_
abuses85119103a_buses
abyes105518533a_b_yes
acetones10310033acetones
achenes12313493achenes
acnes75922623a__cnes
acnodes1037833acnodes
adobes94411533a_dobes
adonis7314063a_donis
adores74420723a_dores
aeons57624653a_eon_s
aerobes9311493aerobes
affines1339483affines
agenes74720253a_genes
agone65924553a_gone_
agonies83016623a_gonies
agons66423783a_gon_s
akenes104817343a_kenes
albinos937663albinos
albites9313213albites
alcoves1297883alcoves
aldoses8311203aldoses
alines65735233a_lines
alkanes113812933alkanes
alkenes114212753alkenes
alkines114415733alkines
alkynes14336463alkynes
allonges937313allonges
almonds10127953almonds
almoner949383almoner
almoners1068133almoners
aloes54933673a_lo_es
alone55732963a_lone_
alpines94016193alpines
amarone9311203amarone_
amasses93912853amasses
amazes175613473am_azes
amazons1836653amazon_s
ambage11510603ambage_
ambaries123312383ambaries
ambaris113112163ambaris
ambeer104511603amb_eer
ambeers11428923ambeers
amber94523213amb__er
amberies122514693amberies
ambers104519583amb_ers
ambiances1545713ambiances
ambiences1545253ambiences
ambient11310093ambient
ambients1246063ambients
ambits103713423amb_its
amble95924643amb_le_
ambled115116373amb_led
ambler104916453amb_ler
amblers115213563amblers
ambo88225143ambo___
amboina1137963amboina
amboyna1443683amboyna
ambroids1346513ambroids
ambsaces1455213ambsaces
ambushes1535803ambushes
amends94713283am_ends
amens75624843am_en_s
aments85219803am_ents
amerces1149853amerces
amices105018013am_ices
amides95722663am_ides
amidines113010853amidines
amidone10349313amidone_
amies76837693am__ies
amine75835383am_ine_
amins75534323am_in_s
amities9317383amities
amitoses1039063amitoses
ammine10314493ammine_
ammonal1137023ammonal
ammonals1245413ammonals
ammonia1148693ammonia
ammonias1247953ammonias
ammonic1349163ammonic
ammonites1348143ammonites
ammono1047373ammon_o
ammos94815823ammo__s
amnions93710913amnion_s
amniotes1036603amniotes
amoks11413553am_o_ks
amole75724593am_ole_
among85813303am_on_g
amongst1045363am_ongst
amounts937043amounts
amours83512663am_ours
amperes11313983amperes
ampoules1275853ampoules
ampules1189433ampules
amuses85117943am_uses
amylenes13105703amylenes
amyloses1347223amyloses
ancone83916953ancone_
anemones10249473anemones
anes45255933a___nes
anions64123033anion_s
annonas738793annonas
anodes74418763a_nodes
anoles64827433a_noles
anyone94612733anyone_
anyons94513503anyon_s
apposes11511473apposes
aproned10311503aproned
aprons8316993apron_s
arbored103811603arbored
arbors84717883arbo_rs
arbours93910043arbours
arbutes939703arbutes
arenes64928393a_renes
areoles71016953areoles
argons75018203argon_s
arkoses113910833arkoses
armbands1355143armbands
armholes1347383armholes
arsines73518843arsines
arsons63917213arson_s
astonies8815113astonies
atone56527983a_tone_
atoned75417543a_toned
atoner64817193a_toner
atoners75013963a_toners
atonies75320953a_tonies
attunes737823attunes
aubades1038753aubades
avions94114393avion_s
axions134713483axion_s
axone125918473a_xone_
axons125517933a_xon_s
azines155517073a_zines
azlons154110423azlon_s
azoles154614613a_zoles
azons146518253a_zon_s
azotes154312223a_zotes
backbones1947253backbones
bambinos1443873bambinos
bamboos1348753bambo_os
banes74945583__banes
benes75536233__benes
bimboes13498733bimbo_es
bines76946793__bines
bizones1837823bizones
bodes84935103__bodes
boles75448603__boles
bonds86126843__bonds
bone65949323__bone_
boned85133243__boned
boner75133083__boner
boners84825433__boners
boney105227313__boney
bongs87828423__bongs
bonks116326463__bonks
bonnes85621453__bonnes
bonus75324323__bonus
bonzes175116103__bonzes
bores76448253__bores
boxes145625073__boxes
buboes104513993bubo_es
bygones1335913bygones
cajones163311333cajones
calzones1948763calzones
camions113916133camion_s
campongs15356123campongs
canzones1939153canzones
carbines123617563carbines
carbons115418943carbon_s
clones84526563_clones
cojones163512103cojones
colones96124433colones
combines142814623combines
cones76457423__cones
cramboes1436543crambo_es
crones84729243_crones
daemones11209163daemones
daimones11208803daimones
damsons1038013damson_s
dapsones1138383dapsones
debone93714783debone_
deboned113411633deboned
deboner103110483deboner
deboners11268113deboners
depones103717093depones
doblones1136763doblones
drones75023433_drones
ebonies9312883_ebonies
ebons74316093_ebon_s
eikones1137853eikones
embanks15295703embanks
embodies1337003embodies
embolies1239153embolies
embolus1135543embolus
embosks1594463embosks
emboss1087383embo_ss
embosses1235963embosses
embowed15236913embowed
embowel14235353embowel
embowels15224133embowels
embower14267413embower
embowers15236453embowers
embows1396823embo_ws
embrues1136473embrues
emotes84620283em_otes
evzones1964523evzones
famines123216263fam_ines
gambades1435863gambades
gambes116318313gamb__es
gambles124016203gamb_les
gamboge1335583gamboge_
gamboled1435873gamboled
gambols1238593gambo_ls
gamines103618463gam_ines
gammoned1444993gammoned
gammoner1345153gammoner
gammoners1444573gammoners
gammons1237973gammon_s
goboes95914443gobo_es
gobonee1077783gobonee
hatboxes2055003hatboxes
hexones17299143hexones
hipbones1546023hipbones
hoboes114717453hobo_es
hones88144493__hones
iambuses1235783iambuses
icones84616383_icones
imbibes1334693imbibes
imbodies1345483imbodies
imbower14235663imbower
imbowers15295093imbowers
imbrues1135503imbrues
imbues1037983imb_ues
imines84918353im_ines
immunes1136083immunes
impone103011863impone_
imponed12279453imponed
imposes113213683imposes
intones7816543intones
ionones7313883ionones
irones64724013_irones
jambes175914053jamb__es
jamboree1944863jamboree
jamborees2043273jamborees
jawbone19134443jawbone_
jawboned21133553jawboned
jawboner20133363jawboner
jawboners21133053jawboners
jones125028183__jones
kampongs17293033kampongs
ketones115014503ketones
lactones10311243lactones
ladrones92710983ladrones
lambies113015113lamb_ies
lazybones2342273lazybones
leones64417723_leones
mabes96331533mab__es
macons104017243macon_s
madrones112912283madrones
mahoes11313103maho_es
malines93625623malines
mamboed14417623mambo_ed
mambos125414493mambo__s
mammons1048513mammon_s
manes76648963_m_anes
marines93928043marines
masoned1039803masoned
masons83916513mason_s
mesnes85216213_mesnes
mines75651953_m_ines
mioses84318853_mioses
modes85537413_m_odes
mokes114631033_m_okes
moles74747923_m_oles
momes95134473_m_omes
monas74732153_m_onas
mondes94322353_m_ondes
money104826843_m_oney
moneys115513623_m_oneys
monies83233163_m_onies
monks116123393_m_onks
monos75930863_m_onos
mons68152263_m_on_s
montes84226933_m_ontes
mooned94216643_mooned
mooner85317833_mooner
mooners94015343_mooners
moons75331003_moon_s
mopes95134983_m_opes
mores76249643_m_ores
motes75944003_m_otes
moues75732843_m_oues
moves106128423_m_oves
muons75816173_muon_s
myopes13419963_myopes
myoses114013843_myoses
nones55639133__nones
oboes75717713_obo_es
oboles83815833_oboles
ombres103911143omb_res
ones46146533___ones
orgones81010793orgones
ozones1539393_ozones
padrones112711043padrones
peones83821043_peones
phones114121213_phones
pinbones1238143pinbones
pinones94717073pinones
pones74547043__pones
pyrones123113303pyrones
rabbonis1245013rabbonis
rambles113118313ramb_les
ramonas9311093ram_onas
rampoles1238893rampoles
ramsons939563ramson_s
rawboned14114253rawboned
rebores95319163rebores
redbones1137593redbones
rezones163213943rezones
riboses9310443riboses
sabines94318483sabines
sambos104315193sambo__s
sambukes1644193sambukes
scones84521303_scones
smokes124814343sm_okes
someones1039063someones
sones55444143__sones
stones65130033_stones
subtones10311383subtones
subzones1947223subzones
syboes1139343sybo_es
tailbones1155263tailbones
tambours1255873tambours
tamponed1336023tamponed
tampons112711563tampon_s
thrones105715843thrones
tones56048663__tones
trombones1345363trombones
trones65629283_trones
umbles103817493umb_les
umbonal1144383umbonal
umbonic1365463umbonic
umbos94613073umbo__s
unboned103014223unboned
unboxes16208303unboxes
vamooses1345523vamooses
vamoses1239153vam_oses
wambles143714023wamb_les
zones145528043__zones

Search took 7 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.406440125.6
2DLD Change Limit1340273966.17321711.8
3Display Results3963960.1402828.6
 (SQL Overall)1786913966.71926594.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.