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

373 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
balatas931183(None) 
balata8614671balata_
ablates92416902ablates
alates64833962_alates
albatas938372_albatas
baklavas1742782baklavas
baklawas1743212baklawas
balas76937212bal__as
balases93815432balases
balboas113710072balboas
balsas86417522bal_sas
bananas93312222bananas
barytas12378282barytas
blats75132502b_lat_s
galateas937122galateas
halalas104214082halalas
malates93522602malates
palapas11311492palapas
palatal9310152palatal
palatals1037772palatals
palates93624932palates
valutas1036532valutas
abacas104414723_abacas
abakas123911743_abakas
abates85825033_abates
abatis84317933_abatis
abayas114011703_abayas
ablate82219213ablat_e
ablated102513443ablated
ablator939843ablator
ablators1069873ablators
ablauts936083ablauts
abwatts1233403abwatts
agamas97413443_agamas
agates76121333_agates
agitas7310593_agitas
alamos8415003_alamos
alands75418373_alands
alans55636173_ala_ns
alants67722023_alants
alarms85913053_alarms
alas46358123_al__as
alaskas1136683_alaskas
alate55340323_alat_e
alated75625143_alated
albas75925393_al_bas
albata839333_albata_
alfas87219043_al_fas
algas65624933_al_gas
alias55834603_al_ias
aliyas93911803_aliyas
almas76629773_al_mas
alohas9411703_alohas
alpacas1137073_alpacas
alphas1139513_alphas
altar55520643_al_tar
altars64518153_altars
altos55822953_al_tos
alts46639903_al_t_s
anabas8314083_anabas
anatase738943_anatase
antas55432033_a_ntas
aortas65417783_aortas
asanas6514113_asanas
atalayas1144783atalayas
atlatls744773atlatls
avatar937523_avatar
avatars1036443_avatars
baals76122703ba_a_ls
baas66844673b__a_as
baases85218013ba_ases
babas96325733b__abas
babkas146010143ba_bkas
bacalao1146613bacalao
bacalaos1245863bacalaos
baccaras1446913baccaras
badass949293bada_ss
badlands1236673badlands
bagass938933baga_ss
bahts105617803ba_ht_s
baits76630583ba_it_s
baizas173810823ba_izas
baklava1643103baklava_
baklawa1643403baklawa_
balance11510263balance
balances1279973balances
balboa10389963balboa_
baldies105317703baldies
baldpates1445233baldpates
balds85524643bal__ds
baleens938473baleens
balers85626933bal_ers
bales76250083bal__es
balkers134915723balkers
balks114926293bal__ks
ballad94315323bal_lad
ballades114211643ballades
ballads104212913ballads
ballast9313993bal_last
ballasts1037933ballasts
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballons93916953ballons
ballots94116033ballots
balls76236413bal__ls
ballutes1037523ballutes
balms95723923bal__ms
balneal936573balneal
bals66354043bal___s
balsa77920413bal_sa_
balsam105612233bal_sam
balsams11579013balsams
banana83213413banana_
bandanas11178573bandanas
bandas95120543ba_ndas
bantam10314063ba_ntam
bantams1149063bantams
baratheas1444913baratheas
barcas101016603ba_rcas
baristas1039723baristas
barites94322333barites
baryta114310293baryta_
barytes124611153barytes
basaltes10367683basaltes
basalts9358963basalts
basmatis1247343basmatis
bastes85330383ba_stes
basts75936933ba_st_s
bates75846343b__ates
baths105922923b__aths
bats66962333b__at_s
batts76727563b__atts
bayamos1434663bayamos
bayards13379683bayards
bazaar17306403baza_ar
bazaars18275883bazaars
bazars174613113baza_rs
beats76042243b_eat_s
belated103520013belated
belauds1036643belauds
belays114313853bela_ys
belgas9311713bel_gas
belts75931163bel_t_s
belugas1035903belugas
bemata10411693bemata_
berates94126853berates
betas75528763b__etas
bettas84913923b_ettas
bhaktas1633643bhaktas
bilboas11438723bilboas
biotas84313923b_iotas
blabs95619633b_la_bs
blacks144914953b_lacks
blades95221253b_lades
blaffs14426623b_laffs
blahs105616513b_la_hs
blains84516373b_lains
blames105121863b_lames
blams95023853b_la_ms
blanks124112893b_lanks
blares85021633b_lares
blasts85116773b_lasts
blat66550953b_lat__
blatant9310673b_latant
blate75933783b_lat_e
blaws105620463b_la_ws
blazes174817353b_lazes
bleats85518613bleat_s
blets75324943b_let_s
blites84721213b_lites
bloats85215763bloat_s
blots75626173b_lot_s
boats75635153b_oat_s
bolas74733763bol__as
bolases93315003bolases
boletes9316063boletes
boletus948643boletus
bolts76232113bol_t_s
bonitas939453bonitas
borates94823013borates
botas75328783b__otas
brats75336013b_rat_s
bravas114913323b_ravas
brazas175812433b_razas
breaths124411183breaths
bwanas1157443b_wanas
bylaws14415833byla_ws
bypaths1743193bypaths
cabalas113516003cabalas
cabanas112413033cabanas
calabash1544253calabash
calamar1149293calamar
calamars1238133calamars
calamatas1345783calamatas
calamus1139243calamus
calathi1247573calathi
calathos1347513calathos
calathus1345013calathus
calesas9411823calesas
callas84526753cal_las
canastas1037693canastas
cantatas103410083cantatas
carates95630603carates
carats85929023carat_s
caritas93316943caritas
casabas1139983casabas
casavas1237813casavas
casitas93312043casitas
cassatas1036673cassatas
chalazas2245893chalazas
dalasis8810533dalasis
daleths1135323daleths
dealates92716683dealates
delates83526283delates
deltas74414823del_tas
dilates83220653dilates
eclats8313033eclat_s
elates65032363_elates
erratas736843erratas
fajitas1734253fajitas
falbalas1345473falbalas
flats86429743_flat_s
flatus94310783_flatus
flautas1036153flautas
flotas94013003_flotas
folates103218453folates
galabias1137733galabias
galagos938143galagos
galahs105512673gala_hs
galangas1046173galangas
galas65731643gal__as
galatea839943galatea
galaxes1538873galaxes
galeas74618503gal_eas
galenas83310333galenas
gallates92815523gallates
galletas9308133galletas
geladas936313geladas
gelates83219583gelates
gelatis83313513gelatis
gelatos83111513gelatos
halachas16317883halachas
halakah17517953halakah
halakahs18426633halakahs
halakhas18386723halakhas
halala94715093halala_
halalah13429383halalah
halalahs14367443halalahs
halals95018313hala_ls
halavah16447013halavah
halavahs17415793halavahs
halites103221193halites
halitus10339963halitus
halloas104318463halloas
halmas117017893hal_mas
halts85230103hal_t_s
halvas124714173hal_vas
hamadas1339663hamadas
hamates122917673hamates
hawalas13348353hawalas
jacanas1638263jacanas
jalaps15299183jala_ps
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kalamatas1543713kalamatas
kalams12310603kala_ms
kalmias1347973kalmias
kalpas124112943kal_pas
kamalas13339123kamalas
kanakas10327213kanakas
karates115617473karates
karats106420493karat_s
katas95922093__katas
lamas75532793__lamas
laths86022403__laths
lats45962703__lat_s
lavas85422223__lavas
litas54923773__litas
llamas888973_llamas
lotas55926303__lotas
mahatmas1543863mahatmas
malaccas1445163malaccas
malangas1136863malangas
malarias10313753malarias
malars85020683mala_rs
malate84624553malat_e
maleates103316343maleates
maltase938903mal_tase
malthas1237913malthas
malts76331753mal_t_s
mananas93414733mananas
manats84623463manat_s
mantas85725363ma_ntas
maracas11313773maracas
marantas10310023marantas
masalas9312053masalas
muletas937383muletas
naganas847983naganas
nalas55528363nal__as
oblates91913243oblates
oxalates1557063oxalates
pajamas18278153pajamas
palabras1267353palabras
palaces114216453palaces
palais8420423pala_is
palapa10310673palapa_
palate84226783palat_e
palatial10410623palatial
palets85122313palet_s
palpates122613063palpates
panadas103312213panadas
panamas113112753panamas
papayas1437273papayas
pastas85422873pa_stas
patacas11311003patacas
pelotas9410723pelotas
pinatas93711483pinatas
platan83913693_platan
platans93413123_platans
plates85432243_plates
plats75531373_plat_s
platys11459853_platys
playas114612283_playas
plazas17409913_plazas
qabalas18289503qabalas
qanats154112813qanat_s
rabatos93010893rabatos
rabats83116223rabat_s
raitas64417673ra_itas
ramadas1039303ramadas
ratatat7412263ratatat
ratatats846063ratatats
reatas64021013_reatas
relates73731423relates
riatas63915083_riatas
salaam8711013sala_am
salaams997703salaams
salads75316963sala_ds
salals65120083sala_ls
salamis9313513salamis
salinas73116093salinas
salivas10309603salivas
salpas85116923sal_pas
salsas65316133sal_sas
salts55431883sal_t_s
salutes73716253salutes
salvias10279933salvias
samaras9312913samaras
sapotas939603sapotas
sataras7315053sataras
savates10312953savates
slates64934063_slates
slats55436903_slat_s
solates73523853solates
sonatas7510293sonatas
splats84817303splat_s
stratas73013573stratas
talars66021683tala_rs
talas55935893tal__as
talukas11316213talukas
taramas9612693taramas
tarantas839193tarantas
tarlatan845063tarlatan
tarlatans944343tarlatans
ulamas8910453_ulamas
vacates12312833vacates
valets93715623valet_s
valuates112811193valuates
valuta938743valuta_
wallas95719393wal_las
zananas16319563zananas

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.1561145455.1
2DLD Change Limit1340273737.15618729.3
3Display Results3733730.1432608.4
 (SQL Overall)1786913737.45523969.3
 
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.