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

233 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
barista931081(None) 
arista6415291_arista
baristas1039721baristas
aristae7312532_aristae
aristas7413522_aristas
aristo6414032_aristo
ballista1045802ballista
barest85327692barest_
barilla9310322barilla
barite84224812bari_te
baryta114310292bar_yta
batiste939742batiste
crista8311802_crista
harissa1035502harissa
turista737442turista
abris75722603abris__
abrosia939273abrosia
agist66325583_agist_
agists75713173_agists
agita6315423_agi_ta
alist56136783_alist_
amrita8411133amri_ta
aorist64827873aorist_
aorists74215833aorists
aria46245423_ari__a
arietta788903_arietta
arise56436433_aris_e
arisen65316793_arisen
arises65233803_arises
aristate8312133_aristate
aristos7312373_aristos
artist64125543_artist_
artiste73813693_artiste
artists74215593_artists
aurist65027253aurist_
aurists74615783aurists
babesia1146623babesia
babiest114414753babiest_
babysat14135233babysat
backstab1845453backstab
backstay1945963backstay
bait66556003ba_i_t_
baith108023133ba_i_th
baits76630583ba_i_ts
baiza164813223ba_i_za
balata8614683ba_lata
ballistae1143793ballistae
balsa77920413ba_ls_a
banish111416043banis_h
banister10199973banister
banksia1335943banksia
baptisia1245013baptisia
baptist11311873baptist_
baptists1236723baptists
barbate11314543barbate
barbet104427883barbet_
barbets114915843barbets
barbital1247053barbital
barbs95928193barbs__
barbut104617003barbut_
barbuts11439843barbuts
barca91319433bar__ca
bards87139643bards__
bares75457133bares__
barfs104826003barfs__
baric96125693bari__c
barillas10310193barillas
baring95135853bari_ng
barites94322333barites
barium10313513bari_um
bariums1139143bariums
barkiest144115153barkiest_
barks115735813barks__
barmiest125212783barmiest_
barms96128463barms__
barniest104815053barniest_
barns76335143barns__
barret84930483barret_
barrets94917103barrets
barrister1145733barrister
bars66564093bar_s__
bartisan1056163bartisan
barytas12378283bar_ytas
baryte115312883bar_yte
basest84720493basest_
basidia1047613basidia
basis75429863basis__
bassist9312743bassist_
bassists1037183bassists
bast66362413ba__st_
baste74829983ba__ste
basts75936933ba__sts
batistes1039713batistes
bearish123013273bearis_h
bemist105216963bemist_
bemists113410703bemists
beretta938463beretta
biota74516823b__iota
biretta947243biretta
boarish123911913boaris_h
bonita8312943boni_ta
borstal939043bor_stal
braise84318753brais_e
braised104014803braised
braises93818873braises
bris65539613b_ris__
brises84927613b_rises
brisk115615983b_ris_k
brisks124611403b_risks
briss75824273b_ris_s
bristle91910103b_ristle
bristly12178063b_ristly
bristol937043b_ristol
brit66350153b_ri_t_
brith104924373b_ri_th
brits76433083b_ri_ts
britska13132883b_ritska
britt75732233b_ri_tt
britts84813443b_ritts
bursa74921523bur_s_a
burst75332243bur_st_
bursts85116243bur_sts
cabresta1243993cabresta
camisa103114323camis_a
camisia112810243camisia
canasta938363canasta
capita102913773capi_ta
carina84325333cari_na
carioca1139683carioca
caritas93316963cari_tas
casita82913703casi_ta
charisma1576363charisma
chrisma1456823chrisma
christy1536623christy
crissa837623_crissa
cristae9310613_cristae
czarist18710223czarist_
czarists1966223czarists
diarist8517113diarist_
diarists9410363diarists
fajita1635923faji_ta
farina94618233fari_na
farinha13357063farinha
frusta937453_frusta
gangsta944513gangsta
garish104516923garis_h
grist65529873_grist_
grists74716483_grists
hariana10310243hariana
harissas1145983harissas
harpist12312363harpist_
harpists1338103harpists
jarina134014063jari_na
jurist134616393jurist_
jurists14409123jurists
karst97228993kar_st_
karsts106012943kar_sts
lariat6629043lariat_
lariats7615053lariats
laris54737463laris__
lyrist9312293lyrist_
lyrists1036963lyrists
maist75535683ma_ist_
maists85817573ma_ists
maranta9311693maranta
marasca1136823marasca
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
marish114319053maris_h
marital92314183mari_tal
narcist9512443narcist_
narcists1078113narcists
naris55735293naris__
orisha936773_orisha
paisa76021073pa_is_a
papist102618753papist_
papists112110453papists
parietal1048773parietal
paris75145943paris__
parises94827183parises
parish115022353paris_h
parity114719873pari_ty
partita9310863partita
pasta76624533pa__sta
purist85525053purist_
purists94014073purists
racist82822793racist_
racists92613323racists
raita54623073ra_i_ta
rapist82520673rapist_
rapists92510753rapists
rarest65725483rarest_
rarity93615493rari_ty
riata54618023__riata
ristra6310713__ristra
sacrist9315423sacrist_
sacristan1143573sacristan
sacrists1039563sacrists
sacristy1345103sacristy
sadist74221353sadist_
sadists83310853sadists
saris54544953saris__
striata7379953striata
tanist6324593tanist_
tanists7313653tanists
tarsia65514273tar_sia
tourista844403tourista
triste63818643_triste
tsarist7712253tsarist_
tsarists857303tsarists
turistas846693turistas
tzarist1659103tzarist_
tzarists1755693tzarists
varia85824203vari__a
variate101316433variate
varietal1145613varietal
variety1337743variety
variola1068893variola
varistor1146393varistor
varsity1356673varsity
verist93823893verist_
verists103613673verists
vista85416603__vista
waist86132383wa_ist_
waists97415453wa_ists
wariest105122503wariest_
warison1037083warison
wrist84827563_wrist_
wrists95415643_wrists
wristy12509703_wristy
yarest95018913yarest_
zariba1736983zari_ba

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272338.00016753.4
3Display Results2332330.0802912.5
 (SQL Overall)1786912338.47021096.9
 
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.