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

346 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
aristas741352(None) 
arista6415291arista_
aristae7312531aristae
aristos7312371aristos
baristas1039721baristas
agists75713172agist_s
agitas7310592agi_tas
amritas939092amri_tas
aorists74215832aorist_s
arias55438022ari__as
ariettas847392ariettas
arises65233802aris_es
aristate8312132aristate
aristo6414032arist_o
artistes83213342artistes
artists74215592artist_s
aurists74615782aurist_s
barista9310812barista_
caritas93316962cari_tas
crista8311802crista_
cristae9310612cristae
grists74716482grist_s
harissas1145982harissas
orishas1036472orishas
raitas64417672rai_tas
riatas63915092_riatas
ristras7311562_ristras
turistas846692turistas
vistas94513272_vistas
wrists95415642wrist_s
abasias9711013abasias
abrosias1049033abrosias
acrasias1048893acrasias
adits66523713adi_t_s
aerosats8411013aerosats
aerostat8410683aerostat
aerostats946713aerostats
afrits9311903afri_t_s
ageists848493ageist_s
agisms9399393agis_ms
agist66325583agist__
agisted938203agisted
agita6315423agi_ta_
agrestal945653agrestal
agrias74315393agri__as
ahimsas1234783ahimsas
airths95414253a_irths
airts55626343a_irt_s
aisles64721143a_isles
aits46355533a_i_t_s
ajivas1655133aji_vas
alaskas1136683alaskas
albatas938373albatas
alias55834603ali__as
alist56136783alist__
aliyas93911803ali_yas
amias75831473ami__as
amigas95912173ami_gas
amiss75823073amis__s
amorists10411333amorist_s
amreetas1044273amreetas
amrita8411133amri_ta_
amusias938583amusias
angsts738863angst_s
animas84418723ani_mas
anises64826693anis_es
antas55432033a__ntas
antistat8413793antistat
antistats949233antistats
aorist64827873aorist__
aoristic10311163aoristic
aortas65417783a_ortas
apostasy1344073apostasy
arbutes939703arbutes
arbutus944843arbutus
areas55935773ar__eas
arecas84817443ar_ecas
arenas65021993ar_enas
areolas71013863areolas
arepas85515703ar_epas
aretes64425353ar_etes
argalas84011093argalas
argots74116033argot_s
arhats9312973arhat_s
aria46245423ari__a_
ariels65119373ari_els
arietta788903arietta
ariette7312373ariette
ariettes8411353ariettes
arils58732203ari__ls
ariosos7409853ariosos
arise56436433aris__e
arisen65316793aris_en
arising83619973arising
armadas1038173armadas
armets84918353armet_s
armillas1046663armillas
arnicas939543arnicas
aroints7313133aroint_s
aromas81018613ar_omas
arras55626133ar__ras
arrests73312683arrest_s
arrises71617583arris_es
arrobas969213arrobas
arses55733873ar_s_es
arsines73518813arsines
arsis55722423ar_s_is
arsons63917213ar_sons
artal55525473ar__tal
artisan759463artis_an
artisans888523artisans
artist64125543artist__
artiste73813693artist_e
artistic10310893artistic
artistry1144453artistry
arts49650263ar__t_s
assists738473assist_s
atresias839473atresias
aubrietas1142833aubrietas
aurist65027253aurist__
autists73814853autist_s
aviates10313063aviates
avisos95410483avis_os
axillas14278963axillas
axises134413993axis_es
axites134913833axi_tes
barillas10310193barillas
barites94322333bari_tes
barytas12378283bar_ytas
batistes1039713batistes
biotas84313923_biotas
brises84927613bris_es
brisks124611403bris_ks
briss75824273bris__s
brisses94314313brisses
bristle91910103bristle
bristles101510433bristles
bristly12178063bristly
bristol937043bristol
bristols1046773bristols
briths115113863bri_ths
brits76433083bri_t_s
britskas14132713britskas
britts84813443bri_tts
cabrestas1344013cabrestas
camisas113411923camis_as
camisias12268603camisias
canastas1037693canastas
carinas93622413cari_nas
cariocas1239663cariocas
casitas93312043casi_tas
cestas85018543_cestas
charismas1655313charismas
cists76624533_cist_s
cistus84611343_cistus
crestal9312133crestal
crests85218703crest_s
crises84529433cris_es
crisis83716343cris_is
crisps104411513cris_ps
crissa837623crissa_
crissal937413crissal
cristate10310603cristate
crits75527573cri_t_s
crustal939023crustal
crusts84916543crust_s
crystal1237433crystal
crystals1347173crystals
cuestas957933cuestas
czarists1966223czarist_s
deists74916433deist_s
diarists9410363diarist_s
distal73615773_distal
ditas65923673_di_tas
drifts10499893drift_s
epistasy1343133epistasy
ericas8315463eri_cas
eristic9814093eristic
eristics10610193eristics
erratas736863erratas
exists134710913exist_s
fajitas1734253faji_tas
farinas103215243fari_nas
farinhas14325363farinhas
feists94915313feist_s
fiestas1038433fiestas
firsts95110923first_s
fists85527543_fist_s
foists95413983foist_s
frisees104411693frisees
frises94124273fris_es
frisks13479263fris_ks
frites94922483fri_tes
friths124313583fri_ths
frits86129103fri_t_s
fritts94613193fri_tts
frosts94214623frost_s
frusta937453frusta_
gangstas1044403gangstas
geishas1135083geishas
gists66026193_gist_s
grifts104511683grift_s
gringas938043gringas
griots74713643griot_s
grisons838993grisons
grist65529873grist__
grister83915413grister
gristers94013403gristers
gristle8169223gristle
gristles9189203gristles
gristly11187333gristly
griths105211653gri_ths
grits65529583gri_t_s
harianas1139163harianas
harissa1035503harissa_
harpists1338103harpist_s
heists96814633heist_s
hists86328373_hist_s
hoists95516023hoist_s
hostas94515823_hostas
iotas54821113__iotas
irises64221173iris_es
iritis63113733iri_tis
isbas71010403__isbas
jarinas143712193jari_nas
joists134711033joist_s
jurists14409123jurist_s
karsts106012943kar_st_s
kists95822113_kist_s
krises105016083kris_es
lariats7615053lariat_s
lists56628693_list_s
litas54923773_li_tas
lyrists1036963lyrist_s
maists85817573maist_s
marantas10310023marantas
marascas1247383marascas
marimbas1444363marimbas
marinas93519393mari_nas
marishes13512553marishes
marital92314183mari_tal
mists76633903_mist_s
narcists1078113narcist_s
odists749853odist_s
orisha936773orisha_
orisons7310563orisons
paisas84317493pais_as
papists112110453papist_s
parietal1048773parietal
parietals1146863parietals
parietes10714543parietes
parises94827183paris_es
parishes13314753parishes
partitas10310253partitas
pastas85422873_pastas
pietas84516503_pietas
pintas85021393_pintas
pistes85325633_pistes
pitas77427673_pi_tas
pittas86014523_pittas
prestos93716083prestos
prests84021263prest_s
priests93810863priest_s
primas104418103pri_mas
prints84320103print_s
prises84133173pris_es
prisms104915503pris_ms
prisons9313223prisons
priss74623893pris__s
prisses94816713prisses
pristane10310343pristane
pristanes11410433pristanes
purists94014073purist_s
quintas163611713quintas
racists92613323racist_s
raias54631123rai__as
raisers73617393raisers
raises64826543rais_es
raisins72715343raisins
raita54623073rai_ta_
rapists92510753rapist_s
reatas64021013_reatas
rests54935873_rest_s
rias45540593_ri__as
riata54618023_riata_
rictal83113183_rictal
rictus8379193_rictus
rifts85718643_rift_s
riojas1335813_riojas
riots54922013_riot_s
risers64624783_risers
rises55244043_ris_es
rishis9312453_rishis
risks94917063_ris_ks
ristra6310713_ristra
risus54216393_ris_us
rites54442553_ri_tes
rotas54827723_r_otas
rusts55026993_rust_s
sacristan1143573sacristan
sacristans1243073sacristans
sacrists1039563sacrist_s
sadists83310853sadist_s
shists96515113shist_s
siestas738813siestas
tanists7313653tanist_s
tarantas839193tarantas
tarsias74013373tar_sias
touristas943373touristas
triptan947543triptan
triptans1047363triptans
trishaw1344753trishaw
trishaws1444003trishaws
trismus935563trismus
tristate8311033tristate
triste63818643trist_e
tristezas1842743tristezas
trusts64714433trust_s
trystes10419993trystes
trysts9448793tryst_s
tsarists857303tsarist_s
turista737443turista_
twists9549753twist_s
tzarists1755693tzarist_s
varias95019903vari__as
variates111214983variates
varietal1145613varietal
varietals1244443varietals
variolas1168533variolas
varistor1146393varistor
varistors1246533varistors
verists103613673verist_s
veritas103012753veri_tas
vestas95916683_vestas
visas84317653_vis_as
vista85416603_vista_
waists97415453waist_s
warisons1136903warisons
whists124613813whist_s
wists86728523_wist_s
wrests95313083wrest_s
wrist84827563wrist__
wristy12509703wrist_y
writes94420333wri_tes
writs86624383wri_t_s
zaribas1836043zari_bas

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.390458182.1
2DLD Change Limit1340273467.04619021.7
3Display Results3463460.1262746.0
 (SQL Overall)1786913467.56223630.1
 
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.