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

252 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
babool10301215(None) 
baboo94319501baboo_
babools11319451babools
baboon103613911baboon
baboos103517011baboos
aboil72217542_aboil
aboon74918702_aboon
babel95821692bab_el
baboons113211072baboons
babul96317712bab_ul
bamboo12310012bamboo_
bamboos1348752bamboos
bazoo163815672bazoo_
bazoos173212622bazoos
befool1137712befool
gaboon93211772gaboon
haboob1377882haboob
taboo73418092taboo_
taboos83815422taboos
abbot9318453_abbot
abbots1039283abbots
abhor10411063_abhor
abloom1039783abloom
abo59045963_ab_o_
abode85518813_abode
abohm1247973_abohm
abolla8410193_abolla
aboma91114603_aboma
aboral8314373_aboral
abort76133583_abort
abos67734413_ab_os
about75229083_about
above105414323_above
abvolt11169833_abvolt
afoot8420113_afoot
afoul8510193_afoul
aldol61212333_aldol
aloof83521573_aloof
argol65317263_argol
atoll57913923_atoll
awol75620673_a_wol
baal67033113ba__al
baba88828343bab__a
babas96325733bab_as
babble94017113babble
babe86835813bab__e
babels105216723babels
babes95834113bab_es
babied114913503babied
babier103515563babier
babies106123643babies
babka137812913bab_ka
babkas146010143babkas
babu85829223bab__u
babuls105413643babuls
babus95620333bab_us
baby116723673bab__y
babydoll1651453babydoll
babyhood1953103babyhood
bacon95620593ba_con
bacons104917583bacons
bagel85116793ba_gel
bagful1237213bagful
bail65042803ba__il
bailor83412603bailor
bal56662723ba___l
balboa10389963balboa
balboas113710073balboas
ball66043323ba__ll
ballon84117493ballon
balloon93711433balloon
ballot84624093ballot
bamboozle2451653bamboozle
banal75925993ba_nal
banco94019393banco_
bancos104713893bancos
bandog1038723bandog
banjo143812443banjo_
banjos15378893banjos
bankbook1543323bankbook
baobab946403baobab
barbal104016663barbal
barbel104317073barbel
barbell11429963barbell
barhop13319643barhop
barlow112911423barlow
baron78131243ba_ron
barong96015823barong
barons85025383barons
barony115915303barony
barrel84517873barrel
barroom1139373barroom
barrow114512763barrow
barstool1044233barstool
baryon111211613baryon
basal75722283ba_sal
basil75122273ba_sil
basion84315853basion
basso76017283basso_
bassoon937613bassoon
bassos85313703bassos
batboy1387533batboy
batboys1465833batboys
batfowl1543593batfowl
bathos116215633bathos
baton75822423ba_ton
batons85519423batons
bawl95326063ba__wl
bayou10512363ba_you
bayous11411143bayous
baywood1646443baywood
bazooka2242623bazooka
bazooms20285383bazooms
beblood12106083beblood
bebop11410793beb_op
bebops1237623bebops
befools1236433befools
befoul1137253befoul
behoof1458683behoof
behowl1445533behowl
benzol1756993benzol
betook12439603betook
bhoot104322093b_hoot
blood85319523b_lood
bloom95918973b_loom
bloop96116153b_loop
boil66335183__boil
boll65634753__boll
bolo65535953__bolo
boo58163663__boo_
boob85932583__boob
booboo1039463booboo
booboos1138143booboos
book106836333__book
boom87435673__boom
boon67142173__boon
boor66130683__boor
boos67955033__boos
boot67759373__boot
bowl96827703__bowl
bradoon1037353bradoon
broil74918223b_roil
broo65129823b_roo_
brood84620243b_rood
brook114717763b_rook
broom95022213b_room
broos75126413b_roos
bubal94218213bub_al
bubo85621903bub_o_
buboed113010003buboed
buboes104513993buboes
bugaboo1244313bugaboo_
bugaboos1343403bugaboos
cabal95222153cab_al
cabob114616803cab_ob
cabobs124311883cabobs
caboodle1343553caboodle
caboose1138273caboose
cahoot11416473cahoot
carol75128613ca_rol
carpool1139223carpool
cibol9512023cib_ol
cool66940493__cool
dahoon1039053dahoon
daybook1744373daybook
dewool1047403dewool
diabolo1065483diabolo
diobol936883diobol
drool65416103_drool
ebook114510803_ebook
fool75330593__fool
gabion93211023gabion
gaboons10289893gaboons
galoot72719153galoot
gambol1138223gambol
gaol56925413ga__ol
garboil1036513garboil
gasohol1143533gasohol
gazoo153112873gazoo_
gazoos163010223gazoos
haboobs1495463haboobs
jabot14321513jab_ot
jabots1538883jabots
kabob134113923kab_ob
kabobs14439293kabobs
karoo92519583karoo_
karoos102415803karoos
kazoo183311533kazoo_
kazoos19259113kazoos
label75019383lab_el
labial84714333labial
labor75117313lab_or
labors84016403labors
labour84210933labour
lagoon7410483lagoon
latosol745283latosol
lawbook1644033lawbook
maltol8310843maltol
maroon83118203maroon
mool67533863__mool
nabob93913733nab_ob
nabobs10388203nabobs
obol65220613_ob_ol
parboil1138323parboil
parol74826273pa_rol
patrol83213023patrol
pool65835953__pool
racoon83814473racoon
ratoon64417373ratoon
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
retool63914483retool
rubaboo1144083rubaboo_
rubaboos1242643rubaboos
sabal75422483sab_al
sabot7931773sab_ot
sabots8314693sabots
safrol937283safrol
salol55222143sa_lol
saloon64418023saloon
saloop84212583saloop
santol64515243santol
school11410723school
seaboot9512333seaboot
shool84523143_shool
snool55118643_snool
spool75219043_spool
stool55619893_stool
subcool1146233subcool
tabooed10267383tabooed
tabooley1342993tabooley
tabor75518393tab_or
tabors84517093tabors
tabouli945843tabouli
tabour84011313tabour
tallol63612223tallol
taxol124011363ta_xol
teabowl1244143teabowl
tool46735683__tool
uncool8610113uncool
upboil1096453upboil
vanpool1243763vanpool
varoom11411413varoom
wadmol1234053wadmol
wahoo112413083wahoo_
wahoos122310593wahoos
wazoo173011173wazoo_
wazoos18288553wazoos
wool76427373__wool
yahoo112911543yahoo_
yahoos12209243yahoos

Search took 9 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162528.21613719.1
3Display Results2522520.1731456.6
 (SQL Overall)1786912528.54520911.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.