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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
parakite1441042(None) 
parakites1549541parakites
parasite10314841parasite
paradise112113872paradise
parakeet14410522parakeet
parasites11313152parasites
partite9317132par_tite
zaratite1747792zaratite
apatite9312963_apatite
aphanite1348773aphanite
arabize1849343_arabize
arenite71017713_arenite
barite84224813bar__ite
boracite1249193boracite
burkite1337003bur_kite
calamite12312533calamite
carabine12412393carabine
carate84734003cara__te
catamite12510593catamite
darkie113714013dar_ki_e
faradise12219393faradise
faradize21237823faradize
fayalite1447053fayalite
granite82017083_granite
jarosite1548383jarosite
kamacite1645293kamacite
karate105320923kara__te
marcasite1346663marcasite
margarite1247513margarite
marlite92917083mar_lite
marmite112413993mar_mite
paganise1139663paganise
paganize2048633paganize
palate84226793pala__te
palatine10316073palatine
parable111819773para_ble
parachute1644333parachute
paraclete1356343paraclete
paracrine1348733paracrine
parade94720643para__de
paradigm1446243paradigm
parading12313863parading
paradises122513203paradises
parae76335703para___e
paraffine1744673paraffine
paraglide1345703paraglide
paragoge1257153paragoge
parakeets1545103parakeets
paralyse1347483paralyse
paralyze2246623paralyze
parameter1349123parameter
parapet11317643parapet_
parapeted1446483parapeted
parapets1239763parapets
paraquet1948783paraquet
parasitic1349523parasitic
parasitise1277403parasitise
parasitize2165863parasitize
paravane1348103paravane
parawing14310583parawing
parbake1538353parbak__e
parbaking1877203parbaking
pardie96021443par_di_e
pardine103616723par_dine
parfait12312053parfait_
parfaits1346913parfaits
parity114719873par__ity
parkade1437583par_kade
parkette14138023parkette
parking143423043par_king
parklike1337493parklike
parlante1039693parlante
parrakeet1545603parrakeet
partake1339643partak__e
partaking1698673partaking
partita9310863par_tita
parvise124211693par_vise
pearlite1039443pear_lite
perlite9317323per_lite
phenakite1864233phenakite
pirate82322883pira__te
praise84419413p_ra_ise
praline93019743p_raline
prate75135983p_ra__te
pyrite11913313pyr__ite
ratite65022423__ratite
ruralite848963ruralite
unakite1138743_unakite
uralite71714103_uralite
uranite72515693_uranite
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.420425454.8
2DLD Change Limit146162916.83021400.0
3Display Results91910.0303033.3
 (SQL Overall)178691917.28024545.5
 
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.