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

161 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
baristas103972(None) 
aristas7413521_aristas
barista9310811barista_
arista6415292_arista_
aristae7312532_aristae
aristos7312372_aristos
barillas10310192barillas
barites94322332bari_tes
barytas12378282bar_ytas
batistes1039712batistes
caritas93316962cari_tas
harissas1145982harissas
turistas846692turistas
abrosias1049033abrosias
agists75713173_agist_s
agitas7310593_agi_tas
amritas939093amri_tas
aorists74215833aorist_s
arias55438023_ari__as
ariettas847393_ariettas
arises65233803_aris_es
aristate8312133_aristate
aristo6414033_arist_o
artistes83213343_artistes
artists74215593_artist_s
aurists74615783aurist_s
babesias1246113babesias
backstab1845453backstab
backstabs1945473backstabs
backstay1945963backstay
backstays2045653backstays
baits76630583ba_i_t_s
baizas173810823ba_i_zas
balatas9311833ba_latas
ballista1045803ballista_
ballistae1143793ballistae
balsas86417523ba_ls_as
banishes131812463banishes
banister10199973banister
banisters11189473banisters
banksias1445893banksias
baptisias1344303baptisias
baptists1236723baptist_s
barbets114915843barbet_s
barbital1247053barbital
barbitals1345263barbitals
barbuts11439843barbut_s
barcas101016603bar__cas
barest85327693barest__
barilla9310323barilla_
barite84224813bari_t_e
bariums1139143bari_ums
barrets94917103barret_s
barrister1145733barrister
barristers1244723barristers
bartisan1056163bartis_an
bartisans1165553bartisans
baryta114310293bar_yta_
barytes124611153bar_ytes
bassists1037183bassist_s
bastes85330383ba__stes
basts75936933ba__st_s
batiste939743batist_e
bemists113410703bemist_s
berettas1046733berettas
biotas84313923b__iotas
birettas1046513birettas
bonitas939453boni_tas
borstal939043bor_stal
borstals1037473bor_stals
braises93818873brais_es
brises84927613b_ris_es
brisks124611403b_ris_ks
briss75824273b_ris__s
brisses94314313b_risses
bristle91910103b_ristle
bristles101510433b_ristles
bristly12178063b_ristly
bristol937043b_ristol
bristols1046773b_ristols
briths115113863b_ri_ths
brits76433083b_ri_t_s
britskas14132713b_ritskas
britts84813443b_ri_tts
bursas85318273bur_s_as
bursitis1045033bursitis
bursts85116243bur_st_s
cabrestas1344013cabrestas
camisas113411923camis_as
camisias12268603camisias
canastas1037693canastas
carinas93622413cari_nas
cariocas1239663cariocas
casitas93312043casi_tas
charismas1655313charismas
crista8311803_crista_
cristae9310613_cristae
czarists1966223czarist_s
diarists9410363diarist_s
fajitas1734253faji_tas
farinas103215243fari_nas
farinhas14325363farinhas
gangstas1044403gangstas
grists74716483_grist_s
harianas1139163harianas
harissa1035503harissa_
harpists1338103harpist_s
jarinas143712193jari_nas
jurists14409123jurist_s
karsts106012943kar_st_s
lariats7615053lariat_s
lyrists1036963lyrist_s
maists85817573ma_ist_s
marantas10310023marantas
marascas1247383marascas
marimbas1444363marimbas
marinas93519393mari_nas
marishes13512553marishes
marital92314183mari_tal
narcists1078113narcist_s
orishas1036473_orishas
paisas84317493pa_is_as
papists112110453papist_s
parietal1048773parietal
parietals1146863parietals
parietes10714543parietes
parises94827183paris_es
parishes13314753parishes
partitas10310253partitas
pastas85422873pa__stas
purists94014073purist_s
racists92613323racist_s
raitas64417673ra_i_tas
rapists92510753rapist_s
riatas63915093__riatas
ristras7311563__ristras
sacristan1143573sacristan
sacristans1243073sacristans
sacrists1039563sacrist_s
sadists83310853sadist_s
tanists7313653tanist_s
tarantas839193tarantas
tarsias74013373tar_sias
touristas943373touristas
tsarists857303tsarist_s
turista737443turista_
tzarists1755693tzarist_s
varias95019903vari__as
variates111214983variates
varietal1145613varietal
varietals1244443varietals
variolas1168533variolas
varistor1146393varistor
varistors1246533varistors
verists103613673verist_s
veritas103012753veri_tas
vistas94513273__vistas
waists97415453wa_ist_s
warisons1136903warisons
wrists95415643_wrist_s
zaribas1836043zari_bas

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621617.53019410.6
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.99922339.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.