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
paradises12251321(None) 
faradises13248981faradises
paradise112113871paradise_
paradoses122510261paradoses
faradise12219392faradise_
faradised14235912faradised
faradisms15256672faradisms
faradizes22237442faradizes
imparadises1653102imparadises
paganises1239732paganises
parabioses1445292parabioses
parades104121472parad__es
paradigms1544652paradigms
paradisal1246882paradisal
paradores12259672paradores
paradoxes19267302paradoxes
parakites1549552parakites
paralyses1448292paralyses
parasites11313162parasites
parises94827192par__ises
parodies11313692parodi_es
parodists1248512parodists
parvises133911922par_vises
praises94121112p_ra_ises
praxises1739062p_raxises
abatises10311013_abatises
appraises1347423appra_ises
arabizes1969103_arabizes
arises65233803_ar__ises
arrises71617583_ar_rises
braises93818873_bra_ises
caddises12329353ca_ddises
canalises11515493canalises
carabines13311483carabines
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
paganizes2148673paganizes
paladins11911003paladi_ns
palatines11313053palatines
paludisms1444013paludisms
pandies104224503pa_ndi_es
papacies1439483papaci_es
parabiosis1444903parabiosis
parables121613573para_bles
parade94720643parad__e_
paraded114014263parad__ed
parader103914863parad__er
paraders113113123parad_ers
paradiddles1651663paradiddles
paradigm1446243paradi_gm
parading12313863paradi_ng
paradisaic1554223paradisaic
paradisiac1553793paradisiac
paradisial1354803paradisial
paradors113411903parad_ors
parados103816053parad__os
paradrops1444963paradrops
paraffines1844333paraffines
paraglides1445023paraglides
paragoges1347263paragoges
parakite14410423parakite_
paralyse1347483paralyse_
paralysed1545743paralysed
paralysis1447323paralysis
paralyzes2346503paralyzes
paraphyses2054753paraphyses
parasite10314843parasite_
parasitises1377383parasitises
parasitoses1384653parasitoses
parataxes1846403parataxes
paravanes1448313paravanes
parawings1535833parawings
parchisis16318573parchisis
parcloses1347963parcloses
pardie96021443par_di_e_
pardine103616733par_dine_
parecisms1547163parecisms
pareses94718883par__eses
paries84742523par__i_es
parishes13314763par__ishes
parities10522983pariti_es
parkades1538273parkad__es
parodied1238343parodi_ed
parodist11412763parodis_t
parridges1384563parridges
parries93925853par_ri_es
parses85534703par___ses
parties93230873par_ti_es
parvise124211693par_vise_
pastises103616053pa_stises
patronises1298453patronises
pavises125315493p__avises
penalises11912773penalises
phrases12711463phra__ses
piracies12312643piraci_es
polarises11514073polarises
porpoises1348433porpoises
practises1349623practises
praise84419413p_ra_ise_
praised104214813p_ra_ised
praiser93413943p_ra_iser
praisers103410843p_ra_isers
pralines102217733p_ralines
prases84429023p_ra__ses
precises123218333p_recises
premises123018273p_remises
previses133814283p_revises
prises84133173p_r__ises
promises122916763p_romises
pyranoses1445863pyranoses
pyridines1546473pyridines
pyrosises1457583pyrosises
radices102314263__radices
radishes1269463__radishes
radiuses937043__radiuses
radixes15259343__radixes
raises64826543__ra_ises
reraises8415643rera_ises
ruralises939123ruralises
sardines92815583sar_dines
sardiuses1044753sar_diuses
sarodists1056593sarodists
tardies84225863tar_di_es
upraises10188473upra_ises
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 Filter1786911486410.423422437.4
2DLD Change Limit1486411487.43619989.4
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.92222556.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.