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

129 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
parasite1031484(None) 
parakite14410421parakite
parasites11313151parasites
jarosite1548382jarosite
marcasite1346662marcasite
paradise112113872paradise
parakites1549542parakites
parasitic1349522parasitic
parasitise1277402parasitise
parasitize2165862parasitize
partite9317132par_tite
zaratite1747792zaratite
abrasive1345753abrasive
adamsite1144423_adamsite
amosite9313163_amosite
apatite9312963_apatite
aphanite1348773aphanite
apposite12410013apposite
arabize1849343_arabize
arcsine94512393_arcsine
arenite71017713_arenite
arsine64021043_ar_sine
artiste73813693_artiste
barite84224813bar__ite
boracite1249193boracite
calamite12312533calamite
campsite1447413campsite
carabine12412393carabine
carate84734003cara__te
catamite12510593catamite
cerusite1047763cerusite
faradise12219393faradise
faradize21237823faradize
farside1138603far_side
fayalite1447053fayalite
granite82017083_granite
jarosites1647373jarosites
kamacite1645293kamacite
karate105320923kara__te
marcasites1445623marcasites
margarite1247513margarite
marlite92917073mar_lite
marmite112413993mar_mite
paganise1139663paganise
paganize2048633paganize
palate84226783pala__te
palatine10316063palatine
parable111819773para_ble
parachute1644333parachute
paraclete1356343paraclete
paracrine1348723paracrine
parade94720643para__de
paradigm1446243paradigm
parading12313863parading
paradises122513203paradises
parae76335703para___e
paraffine1744673paraffine
paraglide1345703paraglide
paragoge1257153paragoge
parakeet14410523parakeet
paralyse1347483paralyse
paralyze2246623paralyze
parameter1349123parameter
parapet11317643parapet_
parapeted1446483parapeted
parapets1239763parapets
paraquet1948783paraquet
paras76143043paras___
parasail1049233parasail
parasailed1344073parasailed
parasails1147583parasails
parasang1147333parasang
parashah1646453parashah
parashioth1852603parashioth
parashot13410143parashot
parashoth1753973parashoth
parasitised1474853parasitised
parasitises1377373parasitises
parasitism1466593parasitism
parasitized2364733parasitized
parasitizes2266103parasitizes
parasitoid13114533parasitoid
parasitoses1384643parasitoses
parasol939553paras_ol
parasoled1246353parasoled
parasols1039263parasols
paravane1348103paravane
parawing14310583parawing
pardie96021443par_di_e
pardine103616723par_dine
paresis93315093paresi_s
parfait12312053parfait_
parfaits1346913parfaits
parity114719873par__ity
parkette14138023parkette
parklike1337493parklike
parlante1039693parlante
parsable12311693parsable
parse75236993par_s__e
parsing103819553par_sing
partita9310863par_tita
parvise124211693par_vise
passive12239593pa_ssive
paste74932953p__as_te
pastie85525523p__astie
pearlite1039443pear_lite
perlite9317323per_lite
pervasive1744483pervasive
phrase11109903phras__e
phrasing1438013phrasing
pirate82322883pira__te
porosity1348593porosity
portside1138163portside
praise84419413p_ra_ise
praline93019743p_raline
prase76128753p_ras__e
prate75135983p_ra__te
preside10715613p_reside
prosit85124593p_rosit_
prostie91617743p_rostie
pyrite11913313pyr__ite
ratite65022423__ratite
resite64128453__resite
ruralite848963ruralite
sparsity1345463spar_sity
uralite71714103_uralite
uranite72515693_uranite
varsity1356673var_sity
zaratites1847003zaratites

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.423422437.4
2DLD Change Limit1461621297.48319532.5
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.96922423.3
 
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.