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

235 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
protists1031336(None) 
protests10310491protests
protist9320221protist_
artists74215592ar_tists
egotists937062egotists
erotisms10310162erotisms
ironists839292ironists
parodists1248512parodists
pietists1038322pietists
pretests10310012pretests
probits112712572probi_ts
profits122911242profi_ts
promises122916762promises
prosaists1157502prosaists
protases102115032protases
protasis102411972protasis
protects1239742protects
protest9317532protest_
protistan1145982protistan
protistans1245202protistans
protistic13410982protistic
protiums1238552protiums
provisos1336912provisos
provosts1336082provosts
acrotisms1347493acrotisms
agonists9289833agonists
altoists848753altoists
amorists10411333amorists
aorists74215833_aorists
aphorists1448263aphorists
arborists1147453arborists
aroints7313133aro_ints
arsonists947413arsonists
artist64125543ar_tist_
artiste73813693ar_tiste
artistes83213343ar_tistes
atomists102610963atomists
autists73814853_autists
azotises1737603azotises
baptists1236723baptists
bromisms1436403bromisms
brutisms1245413brutisms
chutists1335583chutists
cultists10107633cultists
demotists1247323demotists
dentists939263dentists
droits74314313dro_i_ts
egoists887073ego_ists
egotisms1146683egotisms
egotist8411273egotist_
elitists848543elitists
ergotisms1245303ergotisms
eroticists1278183eroticists
erotics91914153eroti_cs
erotism9312303erotis_m
erotizes17311213erotizes
exotisms1746723exotisms
florists1138813florists
flutists11256413flutists
foists95413983_fo_ists
frontlists1344523frontlists
frosts94214623fro__sts
frowsts13426103fro_wsts
gnomists1145473gnomists
grists74716483gr__ists
hoists95516023_ho_ists
holists104413963_holists
hornists11208833hornists
hypnotists1853883hypnotists
iritises839973iritises
ironist7314843ironist_
joists134711033_jo_ists
leftists11235513leftists
lookists1245713lookists
lutists73810273_lutists
monists93614783_monists
mortises10713613mortises
nepotists1145743nepotists
oboists937903obo_ists
odists749853__odists
ologists939443ologists
oralists8611803oralists
orthotists1345153orthotists
palmists12268813palmists
papists112110453p_apists
parodist11412763parodist_
parotids112610413paroti_ds
parotitis1149173parotitis
pastises103616053pastises
peltasts1035703peltasts
peonisms1238443peonisms
persists1049183persists
phonetists1545413phonetists
photics142810483photi_cs
photosets1447833photosets
pianists1049013pianists
pietisms1247463pietisms
pietist9414033pietist_
plenists1038253plenists
poetises10313953poetises
pogromists1543613pogromists
points85618533p_o_ints
poises84226543p_o_ises
pollists10910823pollists
poloists10910523poloists
porisms113713453p_orisms
portents103512823portents
porticos1238373porticos
portions10514413portions
posits85718713p_osi_ts
posts75228783p_o__sts
potions93417423p_otions
potsies93019483p_otsies
practises1349623practises
praises94121103pr_aises
praxises1739063praxises
precasts1239453precasts
precises123218333precises
predicts1339613predicts
preexists1844733preexists
premises123018273premises
premiss113513813premis_s
presifts1366593presifts
prests84021263pr__ests
pretaste10139523pretaste
pretastes11119423pretastes
pretest9517633pretest_
pretexts1735603pretexts
previses133814283previses
previsits1446793previsits
priests93810863pr_iests
prints84320103pr__ints
prises84133173pr__ises
prisms104915503pr__isms
priss74623893pr__is_s
privatists15176053privatists
probit103218353probi_t_
probity14299683probi_ty
process11310403proces_s
proclises1339543proclises
proclisis1346773proclisis
proctitis1348363proctitis
products1376513products
profess1237713profes_s
profiles133211233profiles
profit113016273profi_t_
prohibits1644933prohibits
projects1936413projects
projets1639163pro_jets
prolines102619693prolines
prologists13311173prologists
promines123018803promines
promise113415843promis_e
promised133010873promised
promisee122711333promisee
promisees13246863promisees
promiser122510673promiser
promisers13268203promisers
promisor12266183promisor
promisors13236363promisors
prompts1337473pro_mpts
prophets1539503prophets
propines122618933propines
propjets1935493propjets
proposes122515973proposes
proptoses1349873proptoses
proptosis1348203proptosis
prosaisms1346273prosaisms
prosaist10611583prosaist_
prosects1239473prosects
proses84733473pro__ses
prosiest10416523prosiest_
prosit85124593prosi_t_
prosodists1345943prosodists
prosos85718553pro__sos
pross76529403pro__s_s
prosses94019513pro_sses
prossies101515223prossies
prost75434103pro__st_
prosties101421193prosti_es
proteans102811543proteans
proteas92015123prot_eas
proteases112110833proteases
protect11313633protect_
proteges1149923proteges
proteides12238783proteides
proteids11259943proteids
proteins102114283proteins
protends113010353protends
proteoses112211013proteoses
protested12159113protested
protester111510483protester
protesters12169383protesters
protestor11178493protestor
protestors12169313protestors
proteus92511593prot_eus
proteuses11238993proteuses
protheses1449073protheses
prothesis1449433prothesis
protium11312293proti_um
protons93118003prot_ons
protostar1146693protostar
protostars1246853protostars
protracts1347023protracts
protyles13249833protyles
protyls12298463prot_yls
provides1439883provides
provirus1345453provirus
proviso1237313provis_o
provisoes1446653provisoes
provost1238573provost_
prowess1237903prowes_s
prowest12311533prowest_
proxies163014933proxi_es
purists94014073p_urists
pyrosises1457583pyrosises
racists92613323_racists
rapists92510753_rapists
relists73817053_relists
resists74414923_resists
retests73813853_retests
retints74717013_retints
retwists1135603_retwists
roasts64915413_ro_asts
roosts64916323_ro_osts
rotguts833763_rotguts
rotis56327063_roti__s
rousts617016723_ro_usts
sarodists1056593sarodists
spiritists1244793spiritists
statists8310163statists
tropisms1247723tropisms
utopists1045773utopists
violists1137663violists
wrists95415643wr__ists

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622357.17320376.7
3Display Results2352350.0932526.9
 (SQL Overall)1786912357.42224075.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.