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

135 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
parasites1131316(None) 
parakites1549551parakites
parasite10314841parasite_
jarosites1647372jarosites
marcasites1445622marcasites
paradises122513212paradises
parakite14410422parakite_
parasitic1349522parasitic
parasitise1277402parasitise
parasitises1377382parasitises
parasitism1466592parasitism
parasitizes2266112parasitizes
parasitoses1384652parasitoses
zaratites1847002zaratites
abrasives1444063abrasives
adamsites1243513_adamsites
amosites10311233_amosites
apatites10311293_apatites
aphanites1448273aphanites
arabizes1969103_arabizes
arcsines104010353_arcsines
arenites8917123_arenites
arsines73518833_ar_sines
artistes83213353_artistes
barites94322333bar__ites
boracites1347953boracites
calamites13410713calamites
campsites1546473campsites
carabines13311483carabines
carates95630613cara__tes
catamites1349363catamites
cerastes101111093ceras_tes
cerusites1146523cerusites
faradises13248983faradises
faradizes22237443faradizes
farsides1237993far_sides
fayalites1546063fayalites
granites92116363_granites
harasses11311033haras_ses
jarosite1548383jarosite_
kamacites1744523kamacites
karates115617473kara__tes
marcasite1346663marcasite_
margarites1346533margarites
marlites103415273mar_lites
marmites122212793mar_mites
paganises1239733paganises
paganizes2148673paganizes
palates93624943pala__tes
palatines11313053palatines
palsies94420273pa_lsi_es
pansies94521983pa_nsi_es
papacies1439483papaci_es
parabioses1445293parabioses
parables121613573para_bles
parachutes1744163parachutes
paracletes1446103paracletes
parades104121473para__des
paradigms1544653paradigms
paradise112113873paradise_
paradores12259673paradores
paradoses122510263paradoses
paradoxes19267303paradoxes
paraffines1844333paraffines
paraglides1445023paraglides
paragoges1347263paragoges
parakeets1545113parakeets
paralyses1448293paralyses
paralyzes2346503paralyzes
parameter1349123parameter
parameters1448133parameters
parapeted1446483parapeted
parapets1239773parapet_s
paraquets2044603paraquets
parasailed1344083parasailed
parasails1147593parasails
parasangs1246043parasangs
parashahs1744743parashahs
parasitised1474853parasitised
parasitisms1575503parasitisms
parasitize2165863parasitize
parasitized2364733parasitized
parasitoid13114533parasitoid
parasitoids1493303parasitoids
parasitosis13103983parasitosis
parasoled1246363parasoled
parasols1039273paras_ols
parataxes1846403parataxes
paravanes1448313paravanes
parawings1535833parawings
pareses94718883pares__es
paresis93315093paresi__s
parfaits1346913parfait_s
paries84742523par__i_es
parietes10714553par_ietes
parises94827193par__ises
parishes13314763paris_hes
parities10522983par__ities
parkettes15137593parkettes
parodies11313693parodi_es
parotitis1149183parotitis
parries93925853par_ri_es
parses85534703par_s__es
parties93230873par_ti_es
partitas10310263par_titas
partite9317133par_tite_
parvises133911923par_vises
passives13228823pa_ssives
pastes85233913p__as_tes
pasties94529813p__asties
patsies93919483pa_tsi_es
pearlites1138233pear_lites
perlites10316363per_lites
phrases12711463phras__es
phrasings1544333phrasings
piracies12312643piraci_es
pirates93020333pira__tes
porosities12411483porosities
praises94121113p_ra_ises
pralines102217733p_ralines
prases84429023p_ras__es
prates84633163p_ra__tes
praxises1739063p_raxises
presides11414913p_resides
prosties101421193p_rosties
pyrites12812203pyr__ites
pyrosises1457583pyrosises
ratites74920683__ratites
resites74027793__resites
ruralites947943ruralites
sparsities1247323spar_sities
uralites82112723_uralites
uranites82514643_uranites
varsities1239243var_sities
zaratite1747793zaratite_

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411356.87621617.4
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.35924282.0
 
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.