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

231 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
bamboos134875(None) 
baboos103517011ba_boos
bamboo12310011bamboo_
ambos95321252_amb_os
baboo94319502ba_boo_
babool103012152ba_bool
babools11319452ba_bools
baboon103613912ba_boon
baboons113211082ba_boons
balboas113710072balboas
bambinos1443872bambinos
batboys1465832batboys
bazoos173212622ba_zoos
bimboes13498732bimboes
bimbos124610522bimb_os
booboos1138142booboos
gambols1238592gambols
mamboes135011822mamboes
mambos125414492mamb_os
sambos104315192samb_os
taboos83815432ta_boos
abbots1039283_abbots
abmhos1334973abm_hos
aboon74918703_a_boon
abos67734413_a_b_os
adobos9438453_adobos
ambers104519583_ambers
ambits103713413_ambits
ambles105121863_ambles
ambo88225143_amb_o_
ambones11312683_ambones
amigos94511213_amigos
ammos94815823_am_mos
amnios84912523_amnios
amoks11413553_am_oks
arbors84717883_arbors
babas96325733ba_b_as
babbles104416323babbles
babels105216723ba_bels
babes95834113ba_b_es
babies106123653ba_bies
babkas146010143ba_bkas
babuls105413643ba_buls
babus95620333ba_b_us
bacons104917583ba_cons
bagnios1036073bagnios
bailors93212413bailors
balboa10389963balb_oa
ballons93916963ballons
balloon93711433balloon
balloons103110523balloons
ballots94116033ballots
bambini1336583bambini
bambino1336483bambino
bamboozle2451653bamboozle
bamboozles2551473bamboozles
bams87044453bam___s
bancos104713893ba_ncos
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893ba_njos
bankbook1543323bankbook
bankbooks1643083bankbooks
baobabs1044443baobabs
barbels114514433barbels
barbers114317503barbers
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
barbs95928193barb__s
barbuts11439843barbuts
barhops14288113barhops
barlows12259973barlows
barons85025383ba_rons
barrios9310773barrios
barroom1139373barroom
barrooms1237893barrooms
barrows123411683barrows
baryons121010473baryons
basions94213953basions
bassoon937613bassoon
bassoons1036553bassoons
bassos85313703ba_ssos
batboy1387533batb_oy
bathos116215633ba_thos
batons85519423ba_tons
baubees11348713baubees
baubles113611863baubles
bawbees14337243bawbees
bayamos1434663bayamos
bayous11411153ba_yous
baywood1646443baywood
baywoods1745593baywoods
bazoo163815673ba_zoo_
bazooms20285383bazooms
bebops1237623b_ebops
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilb_os
bimbo114811873bimb_o_
blauboks1642293blauboks
bombers134512593bombers
bombes124916823bomb_es
bombs115818823bomb__s
bonbons1139333bonbons
bonobos1136393bonobos
booboo1039463booboo_
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
boos67955033___boos
boubous1138693boubous
brambles14308973brambles
broos75126413b__roos
buboes104513993b_uboes
bugaboos1343403bugaboos
bulbous1138293bulbous
bumbles134016843bumbles
bumboat1349023bumboat
bumboats1445183bumboats
burbots1168673burbots
burgoos1037123burgoos
busboys14325023busboys
cabobs124311893ca_bobs
caboose1138273ca_boose
cambers134017443cambers
cameos105818003cam_eos
camions113916133camions
camos95927613cam__os
campos125217953cam_pos
carbons115418943carbons
carbos105122263carb_os
carboys144711783carboys
cashoos12310793cashoos
combos125316613comb_os
cramboes1436543cramboes
crambos1336783cramb_os
damsons1038013damsons
daybook1744373daybook
daybooks1843983daybooks
dumbos114111083dumb_os
emboss1087383_emboss
embows1396823_embows
famous11412393fam_ous
gabbros12124653gabbros
gaboon93211773ga_boon
gaboons10289903ga_boons
gambados1444153gambados
gambas115817513gamb_as
gambes116318313gamb_es
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gambles124016203gambles
gamboge1335583gamboge
gamboges1435653gamboges
gambol1138223gamb_ol
gambs105721123gamb__s
gammons1237973gammons
gazoos163010223ga_zoos
gombos114311093gomb_os
gumboot1246493gumboot
gumboots1344253gumboots
gumbos114610873gumb_os
haboob1377883ha_boob
haboobs1495463ha_boobs
halloos103716743halloos
hambone1439313hambone
hambones1539673hambones
harbors12412413harbors
iambics13425643iambics
iambs95815063iamb__s
iambus10468903iamb_us
jabots1538883ja_bots
jambes175914053jamb_es
jambs166014623jamb__s
jumbos17379123jumb_os
kabobs14439303ka_bobs
karoos102415803ka_roos
karroos1139313karroos
kazoos19259113ka_zoos
labors84016413la_bors
lambdas1246243lambdas
lambers113817113lambers
lambies113015113lambies
lambs95921413lamb__s
lampoon11267193lampoon
lampoons12266873lampoons
lawbook1644033lawbook
lawbooks1743743lawbooks
limbos104712143limb_os
mambas125716243mamb_as
mambo115215743mamb_o_
mamboed14417623mamboed
mammons1048513mammons
moos66051303__m_oos
nabobs10388213na_bobs
ramblas112710263ramblas
rambles113118313rambles
ramous8417113ram_ous
ramrods1036583ramrods
ramsons939563ramsons
rubaboos1242653ruba_boos
sabots8314703sa_bots
sambals115213483sambals
sambars115113843sambars
sambas104219263samb_as
sambo95118013samb_o_
samburs11369343samburs
shampoos1544603shampoos
sjamboks2342233sjamboks
spambots1443313spambots
symbols1435523symbols
taboo73418093ta_boo_
tabors84517113ta_bors
tambacs13219363tambacs
tambaks15218153tambaks
tambour1136353tambour
tambours1255873tambours
tamburs11288613tamburs
tampons112711563tampons
tarboosh1343143tarboosh
tattoos738643tattoos
tombolos1245113tombolos
tomboys1435713tomboys
umbos94613073_umb_os
vamoose1235863vam_oose
wahoos122310593wa_hoos
wambles143714023wambles
wazoos18288553wa_zoos
yahoos12209243ya_hoos

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.393454684.5
2DLD Change Limit1340272316.50020619.5
3Display Results2312310.0763039.5
 (SQL Overall)1786912316.96925640.8
 
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.