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

398 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
artists7421559(None) 
artist64125541artist_
artiste73813691artiste
artistes83213341artistes
autists73814851autists
ageists848492ageists
agists75713172a_gists
altoists848752altoists
aorists74215832aorists
arises65233802ar_ises
arista6415292ar_ista
aristas7413522ar_istas
aristo6414032ar_isto
aristos7312372ar_istos
aroints7313132aroints
arrests73312682arrests
arrises71617582arrises
artiest73121992artiest_
artisan759462artisan
artisans888522artisans
artistic10310892artistic
artistry1144452artistry
assists738472assists
attests7278812attests
aurists74615782aurists
autisms94311552autisms
autist64324942autist_
baptists1236722baptists
chartists14126802chartists
grists74716482gr_ists
harpists1338102harpists
lutists73810272lutists
narcists1078112narcists
protists10313362protists
racists92613322racists
rapists92510752rapists
wrists95415642wr_ists
abatises10311013abatises
ableists1036543ableists
accosts11107993accosts
acrotisms1347493acrotisms
actings104512463actings
actins86321103acti_ns
actions94218513actions
actives12311523actives
activists1497043activists
addicts1176013addicts
adits66523713a_di_ts
adjusts1544513adjusts
admits9411413admi_ts
advises11138973advises
aegises8311373aegises
afrits9311903afri_ts
aftosas10147153aftosas
ageisms1056603ageisms
ageist7315383ageist_
agisms9399393a_gisms
agist66325583a_gist_
agonists9289833agonists
airlifts1143633airlifts
airposts1045923airposts
airtimes1037503airtimes
airts55626343a__irts
aits46355533a__i_ts
alarmists1145943alarmists
alist56136783a_list_
altoist7313393altoist_
altruists945413altruists
ambits103713413ambi_ts
amiss75823073a_mis_s
amorists10411333amorists
amortises1178823amortises
angsts738863a_ngsts
animists103010633animists
anises64826693a_nises
anoints7311063anoints
antiars7314623antiars
anticks134612253anticks
antics84621453anti_cs
antings85015583antings
antirusts948143antirusts
antis55033313anti__s
antisag838043antisag
antisex1439693antisex
antistat8413793antistat
antistats949233antistats
aorist64827873aorist_
aptest82917513aptest_
arbalists1148483arbalists
arborists1147453arborists
archaists1446583archaists
arctics1138953arcti_cs
arcuses94814693arcuses
argents84014853argents
argils75213623argi_ls
argots74116033ar_gots
arguses84711743arguses
arhats9312973ar_hats
arias55438023ar_i_as
ariels65119373ar_iels
arils58732203ar_i_ls
ariosos7409853ariosos
arise56436433ar_is_e
arisen65316793ar_isen
aristae7312533ar_istae
arkoses113910833arkoses
armets84918353ar_mets
armies85123693armi_es
armings103811503armings
armlets94610063armlets
armpits1157133armpits
armrests1055383armrests
arnicas939543arnicas
aroids75118223aroi_ds
aroint6328153aroint_
arouses74921293arouses
aroynts1036633aroynts
arpents93613083arpents
arrases71214543arrases
arrest63722633arrest_
arris56824683arri__s
arrives101311513arrives
arses55733873ar__ses
arsines73518813arsines
arsis55722423ar__sis
arsonists947413arsonists
artels66216233art_els
article9310923article
articles10310243articles
artier63419733arti_er
artifacts1443413artifacts
artily92814713arti_ly
artiness81615403artiness
artistries1047253artistries
artless73712513artless
arts49650263ar___ts
artsier768943artsier
artsiest879653artsiest
artsy86012963art_s_y
aspises9611643aspises
assist6314603assist_
astricts1049463astricts
atavists1137583atavists
atheists1138713atheists
atilt54828473a_tilt_
atomists102610963atomists
atriums939043atriums
attaints846493attaints
attest62618613attest_
atticists1167943atticists
attics84413283atti_cs
attires72312953attires
attrits7310613attrits
audits72814113audi_ts
aurist65027253aurist_
autism83815333autis_m
autistic10310103autistic
autistics1147003autistics
avisos95410483a_visos
awaits96411953awai_ts
axises134413993a_xises
azotises1737603azotises
baptises1238923baptises
baptisms1446033baptisms
baptist11311873baptist_
barista9310813bar_ista
baristas1039723bar_istas
bartisan1056163bartisan
bartisans1165553bartisans
bassists1037183bassists
batiste939743batiste
batistes1039713batistes
bemists113410703bemists
betises94816123betises
braises93818873braises
breasts939703breasts
brises84927613br_ises
brisks124611403br_isks
briss75824273br_is_s
brits76433083br_i_ts
britts84813443br_itts
bruises93212913bruises
bruits85714453brui_ts
brutisms1245413brutisms
cambists1437023cambists
casuists1036523casuists
chartist131112133chartist_
chutists1335583chutists
cists76624533__cists
crests85218703cr_ests
crises84529433cr_ises
crisis83716343cr_isis
crisps104411513cr_isps
crista8311803cr_ista
crits75527573cr_i_ts
cruises93514443cruises
crusts84916543cr_usts
cubists11359023cubists
cultists10107633cultists
cutises94414913cutises
czarists1966223czar_ists
dadaists1045583dadaists
deists74916433_deists
delists84414173delists
dentists939263dentists
desists83611723desists
detests83711743detests
diarists9410363diar_ists
drifts10499893dr_ifts
droits74314313droi_ts
earnests837853earnests
earthsets1244123earthsets
egoists887073egoists
egotists937063egotists
elitists848543elitists
enlists749393enlists
entwists1156143entwists
erotisms10310163erotisms
exists134710913_exists
faddists13235543faddists
fantasts1147113fantasts
fascists1336613fascists
fauvists1443843fauvists
feists94915313_feists
fists85527543__fists
flautists1253683flautists
flutists11256413flutists
foists95413983_foists
fraises104215693fraises
frises94124273fr_ises
frisks13479263fr_isks
frits86129103fr_i_ts
fritts94613193fr_itts
frosts94214623fr_osts
frowsts13426103frowsts
fruits94512493frui_ts
gists66026193__gists
grifts104511683gr_ifts
griots74713643gr_iots
grist65529873gr_ist_
grits65529583gr_i_ts
harpist12312353harpist_
harvests14246173harvests
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
hornists11208833hornists
insists739083insists
intwists1145593intwists
irises64221173ir_ises
iritises839973iritises
ironists839293ironists
joists134711033_joists
jurists14409123jurists
karateists1443013karateists
karsts106012943kar__sts
kartings13418523kartings
kists95822113__kists
kraits104912203krai_ts
krises105016083kr_ises
lariats7615053lar_iats
latests73910313latests
leftists11235513leftists
legists899593legists
lists56628693__lists
lutist64317553lutist_
lyrists1036963lyrists
maists85817573_maists
mantises10317923mantises
martians103111613martians
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
martlets103310483martlets
metrists1039853metrists
mists76633903__mists
mitises9315543mitises
monists93614783monists
mortises10713613mortises
mutisms11338453mutisms
narcisms1267263narcisms
narcist9512443narcist_
nonartists1046403nonartists
nudists8356833nudists
oboists937903oboists
obtests9136233obtests
odists749853_odists
oralists8611803oralists
orbits84211443orbi_ts
orgiasts943803orgiasts
orrises71312233orrises
outsits73215253outsits
palmists12268813palmists
papists112110453papists
parises94827183par_ises
parodists1248513parodists
partials101911953partials
partiers103514243partiers
parties93230863parti_es
partings113513733partings
partisan1058423partisan
partisans1167483partisans
partita9310863parti_ta
partitas10310253partitas
partite9317133parti_te
partlets102811513partlets
parvises133911913parvises
pastises103616053pastises
patriots1038053patriots
persists1049183persists
pietists1038323pietists
praises94121103praises
prests84021263pr_ests
pretests10310013pretests
priests93810863priests
prints84320103pr_ints
prises84133173pr_ises
prisms104915503pr_isms
priss74623893pr_is_s
protests10310493protests
protist9320223protist_
purists94014073purists
racisms112310813racisms
racist82822793racist_
raises64826543_raises
rapist82520673rapist_
ratines75328583ratines
ratings84217413ratings
rations74123433rations
ratios64922673rati_os
ratite65022423rati_te
ratites74920683ratites
reests64618893_reests
relists73817053relists
resists74414923resists
resits64725563_resits
rests54935873_r_ests
retests73813853retests
retints74717013retints
retwists1135603retwists
rifts85718643_r_ifts
riots54922013_r_iots
rises55244043_r_ises
risks94917063_r_isks
risus54216393_r_isus
roasts64915413_roasts
roosts64916323_roosts
rousts617016723_rousts
rusts55026993_r_usts
sacrists1039563sacrists
sadists83310853sadists
sarodists1056593sarodists
schists1248543schists
sexists14267673sexists
shists96515113_shists
statists8310163statists
stilts67915313_stilts
stints65119763_stints
tachists1348183tachists
tanists7313653tanists
tarantists1055333tarantists
tartest72517533tartest_
tartiest82718313tartiest_
tartish101512633tartis_h
tartlets8289663tartlets
tests56530193__tests
theists1039153theists
tilts55325613__tilts
tints56030923__tints
titlists837293titlists
tits46145043__ti_ts
traits65121983trai_ts
triste63818643tr_iste
truisms9106823truisms
trusts64714433tr_usts
trysts9448793tr_ysts
tsarists857303tsar_ists
tubists9288323tubists
twists9549753_twists
typists1236173typists
tzarists1755693tzar_ists
untwists1144623untwists
uptilts934733uptilts
urtexts1433143urtexts
varmints1335643varmints
verists103613673verists
vibists1256483vibists
waists97415453_waists
waitlists1244603waitlists
wartiest113614643wartiest_
wartimes1336963wartimes
whists124613813_whists
wists86728523__wists
wrests95313083wr_ests
wrist84827563wr_ist_
wristy12509703wr_isty
writs86624383wr_i_ts

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.406440125.6
2DLD Change Limit1340273986.97019229.1
3Display Results3983980.1402842.9
 (SQL Overall)1786913987.51623774.7
 
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.