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

289 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
balboas11371007(None) 
balboa10389961balboa_
bilboas11438731bilboas
albas75925392_alb_as
babas96325732ba_b_as
babkas146010142ba_bkas
baboos103517012ba_boos
balas76937212bal__as
balatas9311832balatas
ballons93916962ballons
ballots94116032ballots
balsas86417522bal_sas
bamboos1348752bamboos
batboys1465832batboys
bilboa10367842bilboa_
bilboes114410242bilboes
bilbos105011202bilbo_s
bulbous1138292bulbous
halloas104318462halloas
abas68642083_a_b_as
abbas95918643_a_bbas
abbots1039283_abbots
abomas101113583_a_bomas
abos67734413_a_bo_s
alas46358123_al__as
alba68328333_alb_a_
albatas938373_albatas
albs68628573_alb__s
albums10198273_albums
aldols7109713_aldols
alfas87219043_al_fas
algas65624933_al_gas
algors7312553_algors
alias55834603_al_ias
aliyas93911803_aliyas
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
almas76629773_al_mas
aloes54933673_al_oes
alohas9411703_alohas
alphas1139513_alphas
altos55822953_alto_s
ambos95321253_ambo_s
anoas57226493_a_noas
arbors84717883_arbors
baas66844673ba___as
baba88828353ba_b_a_
babbles104416323babbles
babels105216723ba_bels
babes95834113ba_b_es
babies106123653ba_bies
babka137812913ba_bka_
baboo94319503ba_bo_o
babool103012153ba_bool
babools11319453babools
baboon103613913ba_boon
baboons113211083baboons
babuls105413643ba_buls
babus95620333ba_b_us
bacons104917583ba_cons
bailors93212413bailors
baizas173810823ba_izas
baklavas1742783baklavas
baklawas1743213baklawas
balases93815433balases
balata8614683balata_
balcony1435853balcony
baldies105317703baldies
balds85524643bal__ds
baleens938473baleens
balers85626933bal_ers
bales76250083bal__es
balkers134915723balkers
balks114926293bal__ks
ballad94315323bal_lad
ballads104212913ballads
ballast9313993bal_last
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413bal__ls
balmoral1244633balmoral
balmorals1343253balmorals
balms95723923bal__ms
balneal936573balneal
bals66354043bal___s
balsa77920413bal_sa_
balsam105612233bal_sam
balsams11579013balsams
bamboo12310013bambo_o
bananas93312223bananas
bancos104713893banco_s
bandas95120543ba_ndas
bandogs1138363bandogs
bandoras1138743bandoras
banjoes16317313banjoes
banjos15378893banjo_s
baobab946403baob_ab
baobabs1044443baobabs
barbal104016663barb_al
barbels114514433barbels
barbers114317503barbers
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
barbs95928193barb__s
barbuts11439843barbuts
barcas101016603ba_rcas
bareboat1249943bareboat
bareboats1345833bareboats
barhops14288113barhops
barlows12259973barlows
barons85025383ba_rons
barrows123411683barrows
baryons121010473baryons
barytas12378283barytas
basions94213953basions
bassos85313703basso_s
batboy1387533batbo_y
bathos116215633batho_s
batons85519423ba_tons
baubees11348713baubees
baubles113611863baubles
bawbees14337243bawbees
bayous11411153ba_yous
bazookas2341903bazookas
bazooms20285383bazooms
bazoos173212623ba_zoos
bebops1237623b_ebops
belabors1236403belabors
belgas9311713bel_gas
bellboys1544523bellboys
bellows124313303bellows
belons84119413bel_ons
belows114614183bel_ows
belugas1035903belugas
bilbies114712343bilbies
bilbo95513613bilbo__
bilious9310933bilious
billons93013363billons
billows123611293billows
bimboes13498733bimboes
bimbos124610523bimbo_s
blabs95619633blab__s
blauboks1642293blauboks
blazons1836163blazons
bloat75229923b_l_oat
bloats85215763b_l_oats
blobs95620033b_l_obs
blocs95219653b_l_ocs
blogs85319233b_l_ogs
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
blots75626173b_l_ots
blows105423833b_l_ows
boas66150833___boas
bolas74733763bol__as
bolos75531373bol_o_s
bolsons969483bolsons
bonbons1139333bonbons
booboos1138143booboos
boubous1138693boubous
bubbas94110703b_ubbas
buboes104513993b_uboes
bulbar1039583bulb_ar
bulbels11398013bulbels
bulbils11338333bulbils
bulbs96016933bulb__s
bulbuls11346783bulbuls
bullous9311663bullous
bumboat1349023bumboat
bumboats1445183bumboats
burbots1168673burbots
busboys14325023busboys
cabobs124311893ca_bobs
calesas9411833calesas
callas84526753cal_las
callboys1585183callboys
callous93516603callous
calos74431903cal_o_s
carbons115418943carbons
carboras12311583carboras
carbos105122263carbo_s
carboys144711783carboys
catboat11412243catboat
catboats1247873catboats
dagobas1145143dagobas
daltons8310403daltons
elbows1196713_elbows
falbalas1345473falbalas
falcons1239123falcons
fallows133713973fallows
faltboat1346233faltboat
faltboats1444073faltboats
galabias1137733galabias
galas65731643gal__as
galeas74618513gal_eas
galenas83310343galenas
galiots82311323galiots
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoots82410793galoots
galops94712623gal_ops
gambas115817513gamb_as
gambias125010733gambias
gambols1238593gambols
halalas104214083halalas
halloa94918123halloa_
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
halmas117017893hal_mas
haloes94623863hal_oes
halons95720713hal_ons
halos85230253hal_o_s
halvas124714173hal_vas
harbors12412413harbors
hilloas104413553hilloas
holloas103814943holloas
hulloas103911913hulloas
jabots1538883ja_bots
jalops15329593jal_ops
jerboas1636163jerboas
kabobs14439303ka_bobs
kalmias1347973kalmias
kalpas124112943kal_pas
labors84016413la_bors
lambdas1246243lambdas
mallows123714323mallows
malthas1237913malthas
maltols939403maltols
mambas125716243mamb_as
mamboes135011823mamboes
mambos125414493mambo_s
nabobs10388213na_bobs
nalas55528363nal__as
palabras1267353palabras
palapas11311493palapas
pallors9314363pallors
palookas1443843palookas
ramblas112710263ramblas
rasboras1045893rasboras
sabots8314703sa_bots
sabras85116363sa_bras
sailboat1047693sailboat
sailboats1145243sailboats
salinas73116093salinas
salivas10309603salivas
sallows103915553sallows
salmons93713263salmons
salols64017873sal_ols
salons63823693sal_ons
saloons74415323saloons
saloops93510133saloops
salpas85116923sal_pas
salsas65316133sal_sas
salvias10279933salvias
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sambas104219263samb_as
sambos104315193sambo_s
tablas83716163ta_blas
taboos83815433ta_boos
tabors84517113ta_bors
talas55935893tal__as
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallols73311363tallols
tallows103313743tallows
talons64019443tal_ons
talookas1243113talookas
talukas11316213talukas
valors93413773val_ors
valutas1036533valutas
wallas95719393wal_las
wallops123410413wallops
wallows133613533wallows

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.686260482.5
2DLD Change Limit1340272897.07618941.1
3Display Results2892890.1102627.3
 (SQL Overall)1786912897.87222699.6
 
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.