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

251 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
umbones113801(None) 
ambones11312681ambones
bones76446532__bones
debones103315112debones
hambones1539672hambones
impones112712252impones
umbles103817492umb_les
umbonal1144382umbonal
umbonic1365462umbonic
umbos94613072umbo__s
unboned103014222unboned
unboxes16208302unboxes
abodes94417513_abodes
aboves114512843_aboves
agones75719863_agones
amarones10311353amarones
ambages1269623ambages
ambles105121863amb_les
amboinas1246033amboinas
ambos95321253ambo__s
amboynas1543233amboynas
ambries111614553ambries
amidones11348663amidones
amines84727983am_ines
ammines11312673ammines
amoles84122193am_oles
ancones93116343ancones
arbores94016033arbores
atones65225773_atones
axones134614513_axones
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
bugbanes1345153bugbanes
bumbles134016843bumb_les
bumboats1445183bumboats
bygones1335913bygones
cajones163311333cajones
clones84526563_clones
cojones163512103cojones
colones96124433colones
combines142814623combines
cones76457423__cones
crones84729243_crones
debone93714783debone_
deboned113411633deboned
deboner103110483deboner
deboners11268113deboners
depones103717093depones
doblones1136763doblones
drones75023433_drones
dumbcanes1672773dumbcanes
dumbness1334613dumb_ness
dumbos114111083dumbo__s
duotones937643duotones
ebonies9312883_ebonies
ebons74316093_ebon_s
eikones1137853eikones
embanks15295703embanks
embodies1337003embodies
embolies1239153embolies
embolus1135543embolus
embosks1594463embosks
emboss1087383embo_ss
embosses1235963embosses
embowed15236903embowed
embowel14235343embowel
embowels15224133embowels
embower14267403embower
embowers15236453embowers
embows1396823embo_ws
embrues1136473embrues
emotes84620283em_otes
evzones1964523evzones
fumbles143514413fumb_les
gamboges1435653gamboges
goboes95914443gobo_es
gobonee1077783gobonee
gumboils1343893gumboils
gumboots1344253gumboots
gumbos114610873gumbo__s
gumlines11238573gumlines
gummoses1344743gummoses
hambone1439313hambone_
hamboned1637003hamboned
hexones17299143hexones
hipbones1546023hipbones
hoboes114717443hobo_es
hones88144493__hones
humbles143215803humb_les
icones84616383_icones
imbibes1334693imbibes
imbodies1345483imbodies
imbower14235663imbower
imbowers15295093imbowers
imbrues1135503imbrues
imbues1037983imb_ues
imines84918353im_ines
immunes1136083immunes
impone103011863impone_
imponed12279453imponed
imposes113213683imposes
intones7816543intones
ionones7313883ionones
irones64724013_irones
jawbones20134853jawbones
jones125028183__jones
jumbles183013323jumb_les
jumbos17379123jumbo__s
ketones115014503ketones
leones64417723_leones
lummoxes1942553lummoxes
mamboes135011823mambo_es
manes76648963_m_anes
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
mucrones1237603mucrones
mumbles133014433mumb_les
muons75816173_muon_s
murines93718223murines
mutines93117823mutines
mutons84314363muton_s
myopes13419963_myopes
myoses114013843_myoses
nones55639133__nones
numbles113814273numb_les
numbness1234413numb_ness
oboes75717713_obo_es
oboles83815833_oboles
ombres103911143omb_res
ones46146533___ones
orgones81010793orgones
outboxes1737823outboxes
ozones1539393_ozones
peones83821043_peones
phones114121213_phones
pinbones1238143pinbones
pinones94717073pinones
pones74547043__pones
pyrones123113303pyrones
quinones17227753quinones
rebores95319163rebores
redbones1137593redbones
rezones163213943rezones
riboses9310443riboses
rumbles114018393rumb_les
sabines94318483sabines
sawbones13126643sawbones
scones84521303_scones
smokes124814343sm_okes
someones1039063someones
sones55444143__sones
spumones1254953spum_ones
stones65130033_stones
subtones10311383subtones
subzones1947223subzones
sulfones1147683sulfones
summoned1345723summoned
summoner1245533summoner
summoners1344733summoners
summons1158003summon_s
summonses1344543summonses
syboes1139343sybo_es
thrones105715843thrones
tones56048663__tones
trombones1345363trombones
trones65629283_trones
tumbles113816023tumb_les
turbines1039903turbines
udons65411463u_don_s
umbel93612843umb__el
umbeled12208193umbeled
umbels104510593umb_els
umber94617593umb__er
umbered121510113umbered
umbers104215213umb_ers
umbo85516663umbo___
umbonate1245293umbonate
umbrae1038683umbrae_
umbrages1336623umbrages
umbras1038643umb_ras
umpires1137813umpires
unbales92914863unbales
unbans81912623unban_s
unbends10236993unbends
unbinds10267353unbinds
unbolts9247803unbolts
unbonded12299763unbonded
unbonnet1047173unbonnet
unbonnets1143383unbonnets
unbowed132610243unbowed
unboxed17249573unboxed
undines8716083undines
undoes73917403undo_es
undone7914253undone_
unions64216753union_s
unrobes9269733unrobes
untunes72211253untunes
unyokes1466733unyokes
unzoned172310653unzoned
upbinds12234813upbinds
upboils1184703upboils
upbore10247883upbore_
upborne11255133upborne_
upbows1384683upbo_ws
urbane82211383urbane_
urbaner9177133urbaner
urbanest10117533urbanest
urines64724123u_rines
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 Limit1340272515.64023763.7
3Display Results2512510.0932698.9
 (SQL Overall)1786912516.13929107.5
 
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.