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

166 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
paradise11211387(None) 
faradise12219391faradise
paradises122513201paradises
faradised14235912faradised
faradises13248982faradises
faradism14188372faradism
faradize21237822faradize
imparadise1553072imparadise
paganise1139662paganise
parade94720642parad__e
parades104121462parades_
paradigm1446242paradigm
parading12313862parading
paradisal1246882paradisal
parados103816052parados_
paradoses122510252paradoses
parakite14410422parakite
paralyse1347482paralyse
parasite10314842parasite
pardie96021442par_di_e
pardine103616722par_dine
parodies11313692parodies
parodist11412762parodist
parvise124211692par_vise
praise84419412p_ra_ise
appraise1247703appra_ise
arabize1849343_arabize
arise56436433_ar__ise
braise84318753_bra_ise
canalise10816213canalise
carabine12412393carabine
cardiae10713713car_diae
faradic1337693faradi_c
faradisms15256673faradisms
faradized23216313faradized
faradizer22215373faradizer
faradizes22237443faradizes
farads104713273farad_s_
fraise94214913_fra_ise
gradine93317033_gradine
hagadist1347603hagadist
hardies114923233har_dies
imparadised1752173imparadised
imparadises1653103imparadises
maladies11311933maladies
malaise9312673mala_ise
marquise19206173marquise
moralise10314913moralise
nardine82712573nar_dine
nasalise848863nasalise
paddies113715723pa_ddies
padis86227143p__adis_
paeanism1248703paeanism
paganised1346623paganised
paganises1239723paganises
paganish1447773paganish
paganism1369113paganism
paganist11411813paganist
paganize2048633paganize
paise75028333p__a_ise
paladin101011773paladi_n
paladins11911003paladins
palais8420423pala_is_
palatine10316073palatine
palewise1346423palewise
paludism1345323paludism
panadas103312213panadas_
pandies104224503pa_ndies
papacies1439483papacies
parabioses1445283parabioses
parable111819773para_ble
parables121613563parables
paracrine1348733paracrine
paraded114014263parad_ed
parader103914863parad_er
paraders113113113paraders
paradiddle1551773paradiddle
paradigms1544653paradigms
paradisaic1554223paradisaic
paradisiac1553793paradisiac
paradisial1354803paradisial
parador103311413parad_or
paradores12259663paradores
paradors113411903paradors
paradox17358173parad_ox
paradoxes19267293paradoxes
paradrop1344603paradrop
parae76335703para___e
paraffine1744673paraffine
paraglide1345703paraglide
paragoge1257153paragoge
parakites1549543parakites
paralysed1545743paralysed
paralyses1448283paralyses
paralyze2246623paralyze
paramos113213513paramos_
parangs104314373parangs_
paraphs1439313paraphs_
paras76143043para__s_
parasites11313153parasites
parasitise1277403parasitise
paravane1348103paravane
parawing14310583parawing
parchisi15368933parchisi
parclose1247243parclose
pardahs13289673pardahs_
pardee93922023par_d_ee
pardi85723953par_di__
pards85634333par_d_s_
parecism1458533parecism
paresis93315093paresis_
paries84742513par__ies
paris75145943par__is_
parises94827183par__ises
parish115022353par__ish
parities10522973parities
parkade1437583parkad__e
parkades1538273parkades_
parklike1337493parklike
parodic122311723parodi_c
parodied1238343parodied
parodists1248513parodists
parodos103011753parodos_
parridge1254333parridge
parries93925843par_ries
parse75236993par___se
parties93230863par_ties
partite9317133par_tite
parvis116114803par_vis_
parvises133911913par_vises
patronise1198463patronise
pavise114714803p__avise
penalise101013763penalise
perdie94718513per_di_e
phrase11109903phra__se
piracies12312643piracies
polarise10513903polarise
porpoise1248083porpoise
practise12310143practise
praised104214813p_ra_ised
praiser93413943p_ra_iser
praises94121103p_ra_ises
praline93019743p_raline
prase76128753p_ra__se
praxis154012253p_raxis_
praxises1739063p_raxises
precise113518173p_recise
predive13511083p_redive
premise113818553p_remise
previse123713793p_revise
prise74632613p_r__ise
promise113415843p_romise
prudish1376563p_rudish
pyranose1344923pyranose
pyridine1447743pyridine
radish103516913__radish
raise54828053__ra_ise
reraise7316313rera_ise
ruralise839643ruralise
sardine83317393sar_dine
sarodist9510923sarodist
tardies84225863tar_dies
tardive1136893tar_dive
upraise9158603upra_ise
warpwise1642853warpwise
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 Filter1786911461620.420425454.8
2DLD Change Limit1461621667.94018408.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911668.42321214.7
 
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.