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 “opticists” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

287 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
opticists134643(None) 
opticist1248921opticist_
optimists1345291optimists
atticists1167942atticists
opticians1345552opticians
optimises1346082optimises
optimisms1555222optimisms
optimist1256872optimist_
vorticists1546082vorticists
activists1497053activists
atticisms1367413atticisms
atticist10811343atticist_
eroticists1278193eroticists
ethicists1445443ethicists
exoticists1945823exoticists
intimists1147493intimists
lyricists14798353lyricists
mosaicists1443993mosaicists
nativists12116253nativists
oiticicas1353303oiticicas
optician1247243optici_an
optics102810183optic___s
optimise1255583optimis_e
optimised1444313optimised
optimism1445213optimis_m
optimistic1654303optimistic
optimizes2245423optimizes
otitises839163o_titises
otocysts1343503o_tocysts
outcasts10108683out_casts
poeticisms1647353poeticisms
routinists1046093routinists
satirists958923satirists
vorticisms1745783vorticisms
vorticist1448173vorticist_
actinisms1398884actinisms
activisms16106394activisms
activist13109484activist_
adoptionists1553934adoptionists
alpinists1195794alpinists
altoists848754alt_oists
altruists945424altruists
animists103010634_animists
anticity13313604antici_ty
anticults1159384anticults
antiracists1357704antiracists
antirusts948154antirusts
aphorists1448264aphorists
apiarists1147884apiarists
apricots1275404apric_ots
artists74215604art__ists
atavists1137594_atavists
atheists1138724_atheists
atomists102610964_atomists
atticism1268534atticis_m
atticizes2047664atticizes
autecisms1346034autecisms
autists73814854aut__ists
baptists1236724bapt__ists
biblicists1653304biblicists
bioethicists1961994bioethicists
botanists1148204botanists
catechists1744464catechists
cists76624534____cists
civicisms18134824civicisms
copyists1545994cop__yists
criticises1446444criticises
criticisms1656184criticisms
cutinises1148514cutinises
cynicisms1844644cynicisms
deficits1447284defici_ts
dicasts1078704__dicasts
ditheists1345574ditheists
elicits9311234_elici_ts
elitists848544_elitists
empiricists1752054empiricists
entwists1156144ent_wists
epeeists1044794ep_eeists
eroticisms1457994eroticisms
eroticist11712074eroticist_
ethicist1347894ethicist_
exorcists1845044exorcists
exoticisms2155714exoticisms
exoticist1887994exoticist_
explicits2044934explici_ts
fascists1336614_fascists
fatalists12310024fatalists
feminists14227624feminists
fetichisms2043464fetichisms
feticides1547004feticides
fetishists1652304fetishists
futurists1245584futurists
geneticists1454384geneticists
gnosticisms1673624gnosticisms
gothicisms1853394gothicisms
homilists1456814homilists
hygieists1642604hygieists
intimist10410214intimist_
intwists1145594int_wists
iotacisms1346104iotacisms
kineticists1753344kineticists
laicises1039574_laicises
laicisms1247124_laicisms
lapidists1244914lapidists
logicises1256204logicises
luminists1147174luminists
lutanists966844lutanists
lutenists956594lutenists
lutists73810274lut__ists
lyricises149810874lyricises
lyricisms161979014lyricisms
lyricist13718984lyricist_
metalists11412664metalists
metricisms1646534metricisms
metrists1039854met_rists
miticides1447084miticides
morticians1445714morticians
mosaicisms1644184mosaicisms
mosaicist1346024mosaicist_
motorists1149914motorists
mysticisms1944604mysticisms
narcists1078114_narcists
nativisms14105994nativisms
nativist11118684nativist_
naturists947514naturists
nihilists1244854nihilists
nontheists1346064nontheists
obiisms1135674o_bi_isms
oboists937904o__boists
obtests9136234obt__ests
ocicats11137414o_cic_ats
oculists1037134o_culists
odists749854o___dists
offcasts1643014o_ffcasts
officials1743404officials
officiants1853424officiants
officiate1744164officiate
officiates1843694officiates
officious1763874officious
oghamists1543034oghamists
oiticica1244084oitici_ca
ologists939444o_logists
onanists838414o_nanists
oocysts1243924o__ocysts
oologists1039854oologists
opacity1436314op_aci_ty
opencast1244874opencast_
ophidians1543024ophidians
opinions1045934op_inions
opioids1036524op_ioi_ds
opiumisms1542634opiumisms
optatives1445204optatives
optic93715184optic____
optical1149864optic__al
optically1649904optically
optimes1148474opt__imes
optimising1544494optimising
optimize2145504optimi_ze
optimized2344964optimized
optimizer2244124optimizer
optimizers2343024optimizers
optimums1442564opti_mums
optionals1145344optionals
optionees1144344optionees
options93810604opt__ions
oralists8611804o_ralists
organicists1453174organicists
organists1047384organists
orgiasts943804orgi_asts
orthotists1345154orthotists
ostosises946234ostosises
ostracises1245374ostracises
ostracisms1444834ostracisms
otiosity1155764o_tiosity
otitides937294o_titides
otitis63612344o_titi__s
otocyst1244834o_tocyst_
outacts9310214outac__ts
outboasts1144764outboasts
outbursts1143694outbursts
outcast91013744out_cast_
outcaste10119614out_caste
outcastes11118914out_castes
outcity1238454out_ci_ty
outfasts11117234out_fasts
outfeasts12114334outfeasts
outfits102210834out_fi_ts
outhits102213504out_hi_ts
outkiss1137784out_kis_s
outlasts8108714out_lasts
outpaints1145284outpaints
outpoints1145704outpoints
outposts1037254out_posts
outraises9311024outraises
outsits73215254out_si_ts
outskirts1343514outskirts
outwaits1137494outwai_ts
outwits103110864out_wi_ts
overcasts14217854overcasts
ovicides1445464o_vicides
oxidises1644834o_xidises
pacifists1645064pacifists
palmists12268814_palmists
papists112110454_p_apists
persists1049184_persists
physicists2053924physicists
pianists1049014_pianists
pickets154314184_p_ickets
picots104616444_p_ic_ots
pietists1038324_pietists
pipits104713064_p_ipi_ts
plenists1038254_plenists
poeticism1548334poeticis_m
poeticizes2347144poeticizes
polemicists1774224polemicists
polemists1348604polemists
policies122415664polici_es
politicises1546914politicises
pollists10910824_pollists
poloists10910524_poloists
populists1345494populists
positivists1654194positivists
posturists1247074posturists
potiches1539204potic_hes
precasts1239454_precasts
precises123218334_precises
priciest122112904_priciest_
prickets16329084_prickets
priests93810864_pri_ests
protists10313364_protists
publicists1643344publicists
pugilists12124514pugilists
purists94014074_p_urists
putschists1752544putschists
racists92613324__racists
raticides1248694raticides
retwists1135604ret_wists
romanticists16174554romanticists
routinisms1245784routinisms
routinist949494routinist_
satanists948234satanists
satirises9410194satirises
satirist8313504satirist_
scepticisms1963534scepticisms
semitists1148184semitists
septicity1646584septici_ty
shitlists1245534shitlists
sitarists949374sitarists
skepticisms2172774skepticisms
solecists1187074solecists
solicits10311024solici_ts
sophists1347294sop__hists
spiciest122711614sp_iciest_
spiritists1244794spiritists
spirits94112624sp_iri_ts
statists8310164_statists
stockists15194564_stockists
stoicisms1345554stoicisms
stylists11207024_stylists
tachists1348184__tachists
tanists7313664__tanists
theists1039154__theists
tickets134113684__tickets
titlists837294__titlists
totalists9310754totalists
totemists1146374totemists
tubists9288324__tubists
twists9549754__t_wists
typists1236174__typists
ultraists947334ultraists
untwists1144624unt_wists
upcasts11185644up__casts
upthrusts1442144upthrusts
upticks1535154uptic__ks
uptilts934734upt__ilts
urticants1144464urticants
utilises848974_utilises
utopists1045774_utopists
vaticides1546604vaticides
vibists1256484__vibists
vitalists1239224vitalists
vorticism1646394vorticis_m
vorticity1746144vortici_ty
votarists1298604votarists
waitlists1244604waitlists
witticisms1793474witticisms
zootomists2144434zootomists

Search took 36 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 Filter1786911653290.626285448.9
2DLD Change Limit16532928731.3605272.0
3Display Results2872873.54680.9
 (SQL Overall)17869128735.5325029.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.