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

100 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
parakites154955(None) 
parakite14410421parakite_
parasites11313161parasites
paradises122513212paradises
parakeets1545112parakeets
parasite10314842parasite_
zaratites1847002zaratites
apatites10311293_apatites
aphanites1448273aphanites
arabizes1969103_arabizes
arenites8917123_arenites
barites94322333bar__ites
boracites1347953boracites
burkites1436673bur_kites
calamites13410713calamites
carabines13311483carabines
carates95630613cara__tes
catamites1349363catamites
darkies124015753dar_ki_es
faradises13248983faradises
faradizes22237443faradizes
fayalites1546063fayalites
granites92116363_granites
jarosites1647373jarosites
kamacites1744523kamacites
karates115617473kara__tes
marcasites1445623marcasites
margarites1346533margarites
marlites103415273mar_lites
marmites122212793mar_mites
paganises1239733paganises
paganizes2148673paganizes
palates93624943pala__tes
palatines11313053palatines
papacies1439483papaci_es
parabioses1445293parabioses
parables121613573para_bles
parachutes1744163parachutes
paracletes1446103paracletes
parades104121473para__des
paradigms1544653paradigms
paradise112113873paradise_
paradores12259673paradores
paradoses122510263paradoses
paradoxes19267303paradoxes
paraffines1844333paraffines
paraglides1445023paraglides
paragoges1347263paragoges
parakeet14410523parak_eet
paralyses1448293paralyses
paralyzes2346503paralyzes
parameter1349123parameter
parameters1448133parameters
parapeted1446483parapeted
parapets1239773parapet_s
paraquets2044603paraquets
parasitic1349523parasitic
parasitise1277403parasitise
parasitises1377383parasitises
parasitism1466593parasitism
parasitizes2266113parasitizes
parasitoses1384653parasitoses
parataxes1846403parataxes
paravanes1448313paravanes
parawings1535833parawings
parbakes1638343parbak__es
parfaits1346913parfait_s
paries84742523par__i_es
parietes10714553par_ietes
parises94827193par__ises
parities10522983par__ities
parkades1538273par_kades
parkettes15137593parkettes
parkings153610693par_kings
parodies11313693parodi_es
parotitis1149183parotitis
parrakeets1652363parrakeets
parries93925853par_ri_es
partakes1449923partak__es
parties93230873par_ti_es
partitas10310263par_titas
partite9317133par_tite_
parvises133911923par_vises
pearlites1138233pear_lites
perlites10316363per_lites
phenakites1963863phenakites
piracies12312643piraci_es
pirates93020333pira__tes
porkies133416493por_ki_es
praises94121113p_ra_ises
pralines102217733p_ralines
prates84633163p_ra__tes
praxises1739063p_raxises
pyrites12812203pyr__ites
ratites74920683__ratites
ruralites947943ruralites
unakites1237543_unakites
uralites82112723_uralites
uranites82514643_uranites
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.436409841.7
2DLD Change Limit1486411007.09320956.0
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.57523589.6
 
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.