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

226 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
balloon9371143(None) 
ballon84117491ball_on
balloons103110521balloons
galloon82910641galloon
baboon103613912ba_boon
ballonne1045242ballonne
ballons93916962ballons
ballooned1245102ballooned
ballot84624092ball_ot
ballots94116032ballots
ballroom1245022ballroom
bassoon937612bassoon
billion92212172billion
billon83713832bill_on
bullion91911032bullion
galleon8278712galleon
gallon73715812gall_on
galloons9289702galloons
galloot82814222galloot
halloo95118972halloo_
halloos103716742halloos
saloon64418022sa_loon
shalloon1145682shalloon
abloom1039783_abloom
aboon74918703_a_boon
allod64418383_all_od
allods73615083_allods
allot54933873_all_ot
allots64019173_allots
allow85420663_all_ow
allows94517683_allows
alloxan1445773_alloxan
alloy85519973_all_oy
alloys94014563_alloys
aloin55227423_a_loin
aloof83521573_a_loof
aswoon947013_aswoon
azlon144312873_azl_on
baboo94319503ba_boo_
babool103012153ba_bool
baboons113211083ba_boons
baboos103517013ba_boos
baclofen1543103baclofen
bacon95620593ba__con
bailor83412603bail_or
bailors93212413bailors
bailout9414133bailout
balboa10389963ba_lboa
balboas113710073balboas
balcony1435853balcony
baleen8613053ba_leen
ball66043323ball___
ballad94315323ball_ad
ballade104012563ballade
ballads104212913ballads
ballast9313993ballast
balled94926893ball_ed
baller83825203ball_er
ballers94421013ballers
ballet84733973ball_et
ballets93719513ballets
ballies93725743ballies
balling104424763balling
ballonet10314503ballonet
ballonnes1145323ballonnes
ballooning1344723ballooning
balloonist1254683balloonist
balloted1189043balloted
balloter1078893balloter
balloting1238393balloting
ballpoint1345993ballpoint
ballrooms1344143ballrooms
balls76236413ball__s
ballsy11508873ball_sy
ballute938543ballute
bally105530103ball__y
ballyhoo1643193ballyhoo
ballyhoos1743093ballyhoos
bamboo12310013bamboo_
bamboos1348753bamboos
barlow112911423barl_ow
barlows12259973barlows
baron78131243ba__ron
barroom1139373barroom
baryon111211613ba_ryon
baryton1246003baryton
basion84315853ba_sion
bassoons1036553bassoons
bastion9312473bastion
baton75822423ba__ton
baywood1646443baywood
bazillion2043273bazillion
bazoo163815673ba_zoo_
bazoos173212623ba_zoos
beblood12106083beblood
beclown1435423beclown
begloom1255243begloom
bellboy1445123bellboy
bellhop1445053bellhop
bellman1137183bellman
bellmen1138143bellmen
bellow114213353bell_ow
bellows124313303bellows
belon73924113b_el_on
billhook1743653billhook
billions102211793billions
billons93013363billons
billow114111223bill_ow
billows123611293billows
billowy15366903billowy
blazon1736763b_lazon
blood85319523b__lood
bloom95918973b__loom
bloop96116153b__loop
blown105716673b__lown
bollox1548743boll_ox
bolson8410683b_olson
boon67142173b___oon
bradoon1037353bradoon
bridoon1046203bridoon
buffoon1543713buffoon
bulldog1174253bulldog
bullhorn1344463bullhorn
bullions101710043bullions
bullock1537193bullock
bullous9311663bullous
bullpen1135193bullpen
caldron1038153caldron
callan83619603call_an
callboy1465833callboy
callose9313663callose
callous93516603callous
callow114714663call_ow
cardoon104813813cardoon
cartoon94114463cartoon
cullion91910233cullion
dahoon1039053da_hoon
dalapon1044893dalapon
dalton7311273da_lton
falcon11310293fa_lcon
fallen93813373fall_en
falloff1245953falloff
fallout10313503fallout
fallow124713853fall_ow
fallows133713973fallows
gaboon93211773ga_boon
gadroon938173gadroon
gallein8299043gallein
galleons9258443galleons
galliot82214133galliot
gallons83015953gallons
gallooned1144473gallooned
galloots9268963galloots
gallop93311383gall_op
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoot72719163ga_loot
halcyon1543923halcyon
hallo85127553hall_o_
halloa94918123hall_oa
halloas104318463halloas
halloed113314913halloed
halloes104021523halloes
halloing121510073halloing
hallooed12168773hallooed
hallooing1366343hallooing
hallos95425103hall_os
hallot95426783hall_ot
halloth134111253halloth
hallow124818323hall_ow
hallows134417393hallows
halon86124863ha_l_on
harpoon1238313harpoon
hellion10311133hellion
holloo94415253holloo_
holloos104013583holloos
hulloo94511733hulloo_
hulloos104010073hulloos
jargoon1545193jargoon
jillion14188933jillion
lagoon7410483la_goon
lallan63414173lall_an
lampoon11267193lampoon
lardoon83410373lardoon
loon47344793___loon
madzoon1996063madzoon
malison939693malison
mallow114014743mall_ow
mallows123714323mallows
maroon83118203ma_roon
matzoon1896473matzoon
million91813143million
mullion91911173mullion
pallor8313673pall_or
pallors9314363pallors
patroon92811973patroon
pillion92011703pillion
platoon938953platoon
raccoon1176163raccoon
racoon83814473ra_coon
ratoon64417373ra_toon
rattoon7359243rattoon
sallow94315753sall_ow
sallows103915553sallows
sallowy13369343sallowy
salmon84614183sa_lmon
salon55228553sa_l_on
saloons74415323sa_loons
saloop84212583sa_loop
scallion1046793scallion
shalloons1245223shalloons
stallion837523stallion
talion6317713ta_lion
tallboy1265143tallboy
tallol63612223tall_ol
tallols73311363tallols
tallow93714203tall_ow
tallows103313743tallows
tallowy13347633tallowy
talon55824113ta_l_on
wallop113310293wall_op
wallops123410413wallops
wallow123913513wall_ow
wallows133613533wallows
zillion16188773zillion

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 Limit1340272266.70319995.1
3Display Results2262260.0802825.0
 (SQL Overall)1786912267.18924856.2
 
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.