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

211 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
babools1131945(None) 
babool103012151babool_
baboons113211081baboons
baboos103517011baboo_s
babels105216722bab_els
baboo94319502baboo__
baboon103613912baboo_n
babuls105413642bab_uls
bamboos1348752bamboo_s
bazooms20285382bazooms
bazoos173212622bazoo_s
befools1236432befools
gaboons10289902gaboons
haboobs1495462haboobs
taboos83815432taboo_s
abbots1039283_abbots
abhors11410623_abhors
abodes94417513_abodes
abohms1335003_abohms
aboil72217543_aboil_
abolla8410193_abolla
abomas101113583_abomas
aboon74918703_aboo_n
aborts84916183_aborts
abos67734413_ab_o_s
aboves114512843_aboves
abvolt11169833_abvolt
abvolts12104373_abvolts
aldols7109713_aldols
argols74514613_argols
atolls65511353_atolls
awols84713523_a_wols
baals76122703ba__als
babas96325733bab__as
babble94017113bab_ble
babbles104416323babbles
babel95821693bab_el_
babes95834113bab__es
babies106123653bab_ies
babkas146010143bab_kas
baboonish1653193baboonish
babul96317713bab_ul_
babus95620333bab__us
babydoll1651453babydoll
babydolls1751063babydolls
babyhoods2042913babyhoods
bacons104917583ba_cons
bagels95712313ba_gels
bagfuls1334753bagfuls
bailors93212413bailors
bails75933523ba__ils
balboas113710073balboas
ballons93916963ballons
balloons103110523balloons
ballots94116033ballots
balls76236413ba__lls
bals66354043ba___ls
bamboo12310013bamboo__
bamboozle2451653bamboozle
bamboozles2551473bamboozles
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
bankbooks1643083bankbooks
baobabs1044443baobabs
barbells12368823barbells
barbels114514433barbels
barhops14288113barhops
barlows12259973barlows
barongs105310833barongs
barons85025383ba_rons
barrels94514363barrels
barrooms1237893barrooms
barrows123411683barrows
barstools1143543barstools
baryons121010473baryons
basils85717473ba_sils
basions94213953basions
bassoons1036553bassoons
bassos85313703basso_s
batboys1465833batboys
batfowls1642773batfowls
bathos116215633batho_s
batons85519423ba_tons
bawls105719323ba__wls
bayous11411153ba_yous
baywoods1745593baywoods
bazoo163815673bazoo__
bazooka2242623bazooka
bazookas2341903bazookas
bebloods13115233bebloods
bebops1237623beb_ops
befool1137713befool_
befouls1236053befouls
behowls1534443behowls
benzols1836673benzols
bhoots11459913b_hoots
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
boils75427193__boils
bolls75531313__bolls
bolos75531373__bolos
booboos1138143booboos
boobs96221993__boobs
books115729713__books
booms95427123__booms
boons75031913__boons
boors74325013__boors
boos67955033__boo_s
boots75837973__boots
bowls106121433__bowls
bradoons1136763bradoons
broils84114173b_roils
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_roo_s
bubals103513843bub_als
buboes104513993bub_oes
bugaboos1343403bugaboo_s
cabals104020153cab_als
cabobs124311893cab_obs
caboodle1343553caboodle
caboodles1443283caboodles
caboose1138273caboose
cabooses1237863cabooses
cahoots1238473cahoots
carols85124983ca_rols
carpools1237883carpools
cibols1039523cib_ols
cools75632633__cools
dahoons1137753dahoons
daybooks1843983daybooks
dewools1145593dewools
diabolos1174643diabolos
diobols1036543diobols
drools74412813_drools
ebooks12358333_ebooks
fools86824203__fools
gabions102410053gabions
gaboon93211773gaboo_n
galoots82410793galoots
gambols1238593gambols
gaols66717573ga__ols
garboils1145663garboils
gasohols1243723gasohols
gazoos163010223gazoo_s
haboob1377883haboo_b
jabots1538883jab_ots
kabobs14439303kab_obs
karoos102415803karoo_s
kazoos19259113kazoo_s
labels84515683lab_els
labials9299873labials
labors84016413lab_ors
labours9349893labours
lagoons839253lagoons
latosols845003latosols
lawbooks1743743lawbooks
maltols939403maltols
maroons92615553maroons
mools76027173__mools
nabobs10388213nab_obs
obols73715863_ob_ols
parboils1237433parboils
parols84722613pa_rols
patrols93513513patrols
pools74427703__pools
racoons93912433racoons
ratoons73815473ratoons
reboils94111723reboils
rebooks134010513rebooks
reboots93512093reboots
retools73411023retools
rubaboos1242653rubaboo_s
sabals84618863sab_als
sabots8314703sab_ots
safrols1036863safrols
salols64017873sa_lols
saloons74415323saloons
saloops93510133saloops
santols73513323santols
schools1249113schools
seaboots1047093seaboots
shools94919013_shools
snools65715883_snools
spools85115913_spools
stools65117023_stools
subcools1245753subcools
taboo73418093taboo__
tabooed10267383tabooed
tabooley1342993tabooley
tabooleys1441733tabooleys
tabors84517113tab_ors
tabouli945843tabouli
taboulis1045043taboulis
tabours94110093tabours
tallols73311363tallols
taxols13328633ta_xols
teabowls1343463teabowls
tools55325243__tools
upboils1184703upboils
vanpools1343193vanpools
varooms1248883varooms
wadmols1333913wadmols
wahoos122310593wahoo_s
wazoos18288553wazoo_s
wools84421463__wools
yahoos12209243yahoo_s

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.406440125.6
2DLD Change Limit1340272117.18618651.1
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.66823303.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.