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

307 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
gaboons1028990(None) 
baboons113211081baboons
gabions102410051gabions
gaboon93211771gaboon_
aboon74918702_aboon_
babools11319452babools
baboon103613912baboon_
baboos103517012baboo_s
boons75031912__boons
dahoons1137752dahoons
gabion93211032gabion_
gadroons1037012gadroons
gallons83015952gallons
galloons9289702galloons
galoots82410792galoots
gammons1237972gammons
garcons102411642garcons
garrons82713462garrons
gascons10289102gascons
gazoos163010222gazoo_s
gibbons1234982gibbons
gibsons1045042gibsons
goons65326772g__oons
haboobs1495462haboobs
lagoons839252lagoons
maroons92615552maroons
racoons93912432racoons
ratoons73815472ratoons
saloons74415322saloons
taboos83815432taboo_s
abbots1039283_abbots
abhors11410623_abhors
ablins8316193_ablins
abodes94417513_abodes
abohms1335003_abohms
abomas101113583_abomas
aborts84916183_aborts
abos67734413_ab_o_s
abound9239863_abound
abounds10217083_abounds
aboves114512843_aboves
acorns85013013_acorns
adorns74212613_adorns
aeons57624653_a_eons
agons66423783_a_gons
aloins65022203_aloins
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
argons75018203_argons
arsons63917213_arsons
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboo94319503baboo__
babool103012153baboo_l
baboonish1653193baboonish
bacons104917583ba_cons
ballons93916963ballons
balloons103110523balloons
bamboos1348753bamboo_s
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
bassoons1036553bassoons
batons85519423ba_tons
bazooms20285383bazooms
bazoos173212623bazoo_s
bigaroons1243943bigaroons
boobs96221993__boobs
books115729713__books
booms95427123__booms
boon67142173__boon_
boors74325013__boors
boos67955033__boo_s
boots75837973__boots
borons85520543__borons
bosons85016653__bosons
bradoons1136763bradoons
bugaboos1343403bugaboo_s
cabezons2144553cabezons
cabins104418923cab_ins
cabobs124311893cab_obs
cabochons1842793cabochons
caboose1138273caboose
cabooses1237863cabooses
cahoots1238473cahoots
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
cardoons113411943cardoons
cartons94122473cartons
cartoons104012803cartoons
cations94524143cations
cocoons11310563cocoons
coons76737283__coons
croons85418423_croons
dacrons103211033dacrons
daemons10269233daemons
dahoon1039053dahoon_
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
daybooks1843983daybooks
doblons1037043doblons
dobsons1036203dobsons
dragoons1045013dragoons
ebons74316093_eb_ons
ebooks12358333_ebooks
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
gabbers124612833gabbers
gabbing133512033gabbing
gabbles124415413gabbles
gabbros12124653gabbros
gabies93820733gab_ies
gables94222333gab_les
gabling113514543gabling
gabs76740423gab___s
gadoids1036873gadoids
gadroon938173gadroon_
gadzooks23112933gadzooks
gains65729513ga__ins
galiots82311323galiots
galleons9258443galleons
gallon73715813gallon_
galloon82910643galloon_
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoot72719163galoo_t
galops94712623ga_lops
galores82614323galores
gambesons1442343gambesons
gamboges1435653gamboges
gambols1238593gambols
gamins94420043ga_mins
gammon1138903gammon_
ganofs104010293ga_nofs
ganoids939333ganoids
gaols66717573ga__ols
gaposis1038423gaposis
garboils1145663garboils
garcon92912483garcon_
gardens93312093gardens
garotes8614563garotes
garron73113493garron_
gascon9339723gascon_
gaseous839503gaseous
gaskins123510773gaskins
gasohols1243723gasohols
gators74115833ga_tors
gavots1038113ga_vots
gazoo153112873gazoo__
gibbon1135323gibbon_
gibbous1265333gibbous
gibson935123gibson_
gipons9389603g_ipons
girons75014373g_irons
glabrous1145533glabrous
globins10278953globins
globous1036503globous
glooms96211683g_looms
gluons738503g_luons
gnomons1035753gnomons
gobans94412043gob_ans
goblins1039243goblins
goboes95914443gob_oes
gobony1236913gob_ony
gobos86219383gob_o_s
godowns1234673godowns
godroons1045363godroons
godsons966663godsons
gombroons1442953gombroons
goods75124483g__oods
goofs94821003g__oofs
gooks105422883g__ooks
goon57236173g__oon_
goony95519783g__oony
goops86620963g__oops
goos57644913g__oo_s
gorgons938853gorgons
gossoons944893gossoons
gowns95115103g__owns
grabens10367003grab_ens
grisons838993grisons
groans74815063g_roans
groins73917203g_roins
grooms94512523g_rooms
guenons836563guenons
guidons936623guidons
gumboots1344253gumboots
gyrons105511223g_yrons
haboob1377883haboo_b
hadrons113314303hadrons
hagdons1258523hagdons
halons95720713ha_lons
harpoons1337483harpoons
jabots1538883jab_ots
jargons1558203jargons
jargoons1644663jargoons
jigaboos1842853jigaboo_s
kabobs14439303kab_obs
kaons95014853ka__ons
karoos102415803karoo_s
kations114013663kations
kazoos19259113kazoo_s
kroons103711243_kroons
labors84016413lab_ors
labours9349893labours
ladrons83813193ladrons
lagoon7410483lagoon_
lampoons12266873lampoons
lardons83914493lardons
lardoons9398483lardoons
lawbooks1743743lawbooks
loons55731723__loons
macons104017243ma_cons
macrons113514893macrons
madzoons20124773madzoons
mammons1048513mammons
maroon83118203maroon_
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
matzoons19105083matzoons
moons75331003__moons
nabobs10388213nab_obs
nasions73112383nasions
nations74720563nations
natrons73215663natrons
noons54125283__noons
paeons83915523pa_eons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
patroons102710603patroons
platoons1038683platoons
poons75430973__poons
rabbins112811343rabbins
rabboni1144803rabboni
rabbonis1245013rabbonis
raccoons1265453raccoons
racons84319343ra_cons
racoon83814473racoon_
radons74118533ra_dons
ramsons939563ramsons
rations74123433rations
ratoon64417373ratoon_
rattons73815323rattons
rattoons8327513rattoons
rayons94113343ra_yons
rebooks134010513rebooks
reboots93512093reboots
ribbons1136253ribbons
rigadoons1142633rigadoons
sabatons1037843sabatons
sabayons1343963sabayons
sabins85521983sab_ins
sabots8314703sab_ots
salmons93713263salmons
salons63823693sa_lons
saloon64418023saloon_
saloops93510133saloops
seaboots1047093seaboots
simoons937943simoons
spoons84116023_spoons
suborns939493suborns
swoons94511143_swoons
taboo73418093taboo__
tabooed10267383tabooed
tabooing11186313tabooing
taborins103310223taborins
tabors84517113tab_ors
tabours94110093tabours
tabuns8489223tab_uns
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tarpons92612213tarpons
tauons63412673ta_uons
taxons134211503ta_xons
toons55027533__toons
tycoons1235173tycoons
varooms1248883varooms
waggons1235503waggons
wagons103911213wa_gons
wahoos122310593wahoo_s
wanions104011373wanions
wantons103713013wantons
wazoos18288553wazoo_s
yahoos12209243yahoo_s
yapons114411773ya_pons
yaupons12345683yaupons
zoons144919693__zoons

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.420425454.8
2DLD Change Limit1340273076.26621389.6
3Display Results3073070.1232495.9
 (SQL Overall)1786913076.80926243.4
 
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.