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

148 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
paradises12251320(None) 
faradises13248981faradises
paradise112113871paradise_
paradoses122510251paradoses
faradise12219392faradise_
faradised14235912faradised
faradisms15256672faradisms
faradizes22237442faradizes
imparadises1653102imparadises
paganises1239722paganises
parabioses1445282parabioses
parades104121462parad__es
paradigms1544652paradigms
paradisal1246882paradisal
paradores12259652paradores
paradoxes19267292paradoxes
parakites1549542parakites
paralyses1448282paralyses
parasites11313152parasites
parises94827182par__ises
parodies11313692parodi_es
parodists1248512parodists
parvises133911912par_vises
praises94121102p_ra_ises
praxises1739062p_raxises
abatises10311013_abatises
appraises1347423appra_ises
arabizes1969103_arabizes
arises65233803_ar__ises
arrises71617583_ar_rises
braises93818873_bra_ises
caddises12329353ca_ddises
canalises11515493canalises
carabines13311473carabines
faradism14188373faradis_m
faradize21237823faradize_
faradized23216313faradized
faradizer22215373faradizer
faradizers23223643faradizers
fraises104215693_fra_ises
gradines103615253_gradines
graduses1046453_graduses
hagadists1445073hagadists
harasses11311033hara_sses
hardasses1346453hardasses
hardies114923233har_di_es
imparadise1553073imparadise_
imparadised1752173imparadised
maladies11311933maladi_es
malaises10312333mala_ises
marquises20225703marquises
moralises11314003moralises
nasalises948113nasalises
paddies113715723pa_ddi_es
paeanisms1347583paeanisms
paganise1139663paganise_
paganised1346623paganised
paganisms1447933paganisms
paganists1247643paganists
paganizes2148663paganizes
paladins11911003paladi_ns
palatines11313033palatines
paludisms1444013paludisms
pandies104224503pa_ndi_es
papacies1439473papaci_es
parabiosis1444903parabiosis
parables121613563para_bles
parade94720643parad__e_
paraded114014263parad__ed
parader103914863parad__er
paraders113113113parad_ers
paradiddles1651653paradiddles
paradigm1446243paradi_gm
parading12313863paradi_ng
paradisaic1554223paradisaic
paradisiac1553793paradisiac
paradisial1354803paradisial
paradors113411903parad_ors
parados103816053parad__os
paradrops1444963paradrops
paraffines1844323paraffines
paraglides1445013paraglides
paragoges1347253paragoges
parakite14410423parakite_
paralyse1347483paralyse_
paralysed1545743paralysed
paralysis1447313paralysis
paralyzes2346493paralyzes
paraphyses2054743paraphyses
parasite10314843parasite_
parasitises1377373parasitises
parasitoses1384643parasitoses
parataxes1846393parataxes
paravanes1448303paravanes
parawings1535823parawings
parchisis16318573parchisis
parcloses1347963parcloses
pardie96021443par_di_e_
pardine103616723par_dine_
parecisms1547163parecisms
pareses94718883par__eses
paries84742513par__i_es
parishes13314753par__ishes
parities10522973pariti_es
parkades1538273parkad__es
parodied1238333parodi_ed
parodist11412763parodis_t
parridges1384553parridges
parries93925843par_ri_es
parses85534703par___ses
parties93230863par_ti_es
parvise124211693par_vise_
pastises103616053pa_stises
patronises1298433patronises
pavises125315493p__avises
penalises11912773penalises
phrases12711463phra__ses
piracies12312643piraci_es
polarises11514073polarises
porpoises1348433porpoises
practises1349623practises
praise84419413p_ra_ise_
praised104214813p_ra_ised
praiser93413943p_ra_iser
praisers103410833p_ra_isers
pralines102217723p_ralines
prases84429023p_ra__ses
precises123218333p_recises
premises123018273p_remises
previses133814283p_revises
prises84133173p_r__ises
promises122916763p_romises
pyranoses1445853pyranoses
pyridines1546473pyridines
pyrosises1457583pyrosises
radices102314263__radices
radishes1269463__radishes
radiuses937043__radiuses
radixes15259343__radixes
raises64826543__ra_ises
reraises8415643rera_ises
ruralises939123ruralises
sardines92815563sar_dines
sardiuses1044753sar_diuses
sarodists1056593sarodists
tardies84225863tar_di_es
upraises10188473upra_ises
zaratites1847003zaratites

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.436409841.7
2DLD Change Limit1486411487.92318760.7
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.42221217.2
 
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.