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
parakites154954(None) 
parakite14410421parakite_
parasites11313151parasites
paradises122513202paradises
parakeets1545102parakeets
parasite10314842parasite_
zaratites1847002zaratites
apatites10311283_apatites
aphanites1448263aphanites
arabizes1969103_arabizes
arenites8917103_arenites
barites94322333bar__ites
boracites1347943boracites
burkites1436673bur_kites
calamites13410713calamites
carabines13311463carabines
carates95630613cara__tes
catamites1349363catamites
darkies124015753dar_ki_es
faradises13248983faradises
faradizes22237443faradizes
fayalites1546063fayalites
granites92116363_granites
jarosites1647373jarosites
kamacites1744523kamacites
karates115617473kara__tes
marcasites1445623marcasites
margarites1346533margarites
marlites103415263mar_lites
marmites122212793mar_mites
paganises1239723paganises
paganizes2148663paganizes
palates93624933pala__tes
palatines11313033palatines
papacies1439473papaci_es
parabioses1445283parabioses
parables121613563para_bles
parachutes1744153parachutes
paracletes1446093paracletes
parades104121463para__des
paradigms1544653paradigms
paradise112113873paradise_
paradores12259653paradores
paradoses122510253paradoses
paradoxes19267293paradoxes
paraffines1844323paraffines
paraglides1445003paraglides
paragoges1347253paragoges
parakeet14410523parak_eet
paralyses1448283paralyses
paralyzes2346493paralyzes
parameter1349123parameter
parameters1448113parameters
parapeted1446463parapeted
parapets1239763parapet_s
paraquets2044593paraquets
parasitic1349523parasitic
parasitise1277403parasitise
parasitises1377373parasitises
parasitism1466593parasitism
parasitizes2266103parasitizes
parasitoses1384643parasitoses
parataxes1846393parataxes
paravanes1448293paravanes
parawings1535823parawings
parbakes1638343parbak__es
parfaits1346913parfait_s
paries84742513par__i_es
parietes10714543par_ietes
parises94827183par__ises
parities10522973par__ities
parkades1538273par_kades
parkettes15137593parkettes
parkings153610683par_kings
parodies11313693parodi_es
parotitis1149173parotitis
parrakeets1652363parrakeets
parries93925843par_ri_es
partakes1449923partak__es
parties93230863par_ti_es
partitas10310253par_titas
partite9317133par_tite_
parvises133911913par_vises
pearlites1138233pear_lites
perlites10316353per_lites
phenakites1963863phenakites
piracies12312643piraci_es
pirates93020333pira__tes
porkies133416493por_ki_es
praises94121103p_ra_ises
pralines102217723p_ralines
prates84633163p_ra__tes
praxises1739063p_raxises
pyrites12812203pyr__ites
ratites74920683__ratites
ruralites947943ruralites
unakites1237543_unakites
uralites82112723_uralites
uranites82514643_uranites
zaratite1747793zaratite_

Search took 9 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.220812231.8
2DLD Change Limit1486411008.12318298.8
3Display Results1001000.0631587.3
 (SQL Overall)1786911008.40621257.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.