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

112 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
paradoses12251025(None) 
paradises122513201paradises
paradores12259651paradores
paradoxes19267291paradoxes
faradises13248982faradises
parabioses1445282parabioses
parades104121462parad__es
paradise112113872paradise_
paradors113411902parado_rs
parados103816052parado__s
paragoges1347252paragoges
paralyses1448282paralyses
parcloses1347962parcloses
pyranoses1445852pyranoses
acidoses1136773_acidoses
agaroses938823_agaroses
aldoses8311203_a_ldoses
apodoses1136653_apodoses
arkoses113910833_ar_koses
calvadoses1642483calvadoses
caracoles13310073caracoles
extradoses1853453extradoses
faradise12219393faradise_
faradised14235913faradised
faradisms15256673faradisms
faradizes22237443faradizes
farandoles1462973farandoles
furanoses1244993furanoses
graduses1046453_graduses
harasses11311033hara_sses
hardasses1346453hardasses
hardnoses1346233hardnoses
imparadises1653103imparadises
intradoses1143593intradoses
karaokes1145013kara_okes
keratoses1346093keratoses
lordoses937143lor_doses
megadoses1344663megadoses
narcoses103910543nar_coses
paganises1239723paganises
pandores11312453pa_ndores
papadoms1575923papado_ms
papooses1248053pa_pooses
pappooses1243993pappooses
parabiosis1444903parabiosis
parables121613563para_bles
parabolas1347003parabolas
parade94720643parad__e_
paraded114014263parad__ed
parader103914863parad__er
paraders113113113parad_ers
paradigms1544653paradigms
paradisal1246883paradisal
parador103311413parado__r
paradox17358173parado__x
paradrops1444963paradrops
parafoils1445503parafoils
paraforms1645563paraforms
paragoge1257153paragoge_
paragoned1357063paragoned
paragons11311503parago_ns
parakites1549543parakites
paralyse1347483paralyse_
paralysed1545743paralysed
paralysis1447313paralysis
paralyzes2346493paralyzes
paramos113213513paramo__s
paramours1345653paramours
paranoea1048553parano_ea
paranoeas1147513paranoeas
paranoias11410443paranoias
paranoics1347653paranoics
paranoids1248913paranoids
paraphyses2054743paraphyses
parasites11313153parasites
parasitoses1384643parasitoses
parasoled1246353parasoled
parasols1039263paraso_ls
parataxes1846393parataxes
paravanes1448293paravanes
parazoans2045603parazoans
parclose1247243parclose_
pardoned12189333par_doned
pardoner11189443par_doner
pardoners12208213par_doners
pardons103817623par_do_ns
pareses94718883par__eses
parises94827183par__ises
parkades1538273parkad__es
parodies11313693parod_ies
parodists1248513parodists
parodos103011753parodo__s
paroles95025883par__oles
parses85534703par___ses
parvises133911913par_vises
passadoes1245093passado_es
pathoses13412773pa_thoses
petasoses1145443petasoses
pharoses13310313p_haroses
phrases12711463phra__ses
picadores1444363picadores
praises94121103p_ra_ises
prases84429023p_ra__ses
praxises1739063p_raxises
proposes122515973p_roposes
proses84733473p_r__oses
purposes1237823pur_poses
pyranose1344923pyranose_
radomes10311053__radomes
reredoses1045773reredoses
saroses73619333sar__oses
varicoses1446653varicoses

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.486367677.0
2DLD Change Limit1486411127.34320242.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.87522690.9
 
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.