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

130 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
perilous1031069(None) 
parlous9414292par_lous
peridots1138322peridots
perigons11310082perigons
perillas10310822perillas
perilously1546432perilously
perils84121852peril__s
periods10312242peri_ods
peritus9311802peri_tus
pervious1337542pervious
petalous1058972petalous
pilous84717752p__ilous
pyritous1344932pyritous
serious73616282seri_ous
apetalous1144583apetalous
caribous1258823caribous
carious93320283cari_ous
cernuous1055013cernuous
cerous85821203cer__ous
curious93813563curi_ous
desirous947783desirous
devious1138523devi_ous
emulous937343_emulous
epilogs1076583_epilogs
epsilons1044223epsilons
ferreous1146043ferreous
ferrous1049803fer_rous
furious103110633furi_ous
heinous1038853he_inous
heriots10312063heri_ots
heritors11310903heritors
imperious1346583imperi_ous
jealous1438093je_alous
melilots1046553melilots
merinos9311983merino_s
merlons93311273mer_lons
merlots92710123mer_lots
nebulous1045093nebulous
nervous1037143ner_vous
nubilous1044843nubilous
parlors9312913par_lors
parlour937263par_lour
parlours1036153par_lours
parous84024163par__ous
patulous10116363patulous
pectinous1345553pectinous
pedalos10329703pedalo_s
pediculous1553373pediculous
pelorus939273pe__lorus
pendulous1243863pendulous
penurious1145823penuri_ous
pepinos1137693pepino_s
peplos101211543pe_plo_s
peplus10138343pe_pl_us
perdus93711273per__dus
pereions10310853pereions
pereons92815003per_eons
perfidious1653673perfidious
pergolas1158233pergolas
periapts1237273periapts
periblems1543483periblems
pericope1447783pericope
pericopes1547873pericopes
peridium1349023peridium
peridot10514243perido_t
perigees1189503perigees
perigon1039853perigo_n
perigynous1653013perigynous
peril75425953peril___
periled10316323peril_ed
periling11316863periling
perilla9311233peril_la
perilled11410113perilled
perilune1046983perilune
perilunes1147163perilunes
perineum1246523perineum
period9314983peri_o_d
peripatus1344933peripatus
perique1837523peri_que
periques1937653periques
peris75537073peri___s
perishes13313753perishes
periwigs1444193periwigs
perlites10316363perlites
pernicious1445503pernicious
pernods1038483per_nods
perrons93115483per_rons
persons93717013per_sons
petioles10311643petioles
petrous92714423pe_trous
pilaus84114133p__ilaus
pileous9510523p__ileous
pileus84514943p__ileus
pilots84018873p__ilots
pilus75921063p__il_us
pious74621273p__i_ous
poilus82210573p_oil_us
populous1245953populous
porous84419483por__ous
precious12310593precious
previous1337823previous
priapus1134353p_riapus
prills84015613p_ril_ls
primos104514423p_rimo_s
primus103712173p_ri_mus
prions84317783p_ri_ons
priors83914483p_ri_ors
prisons9313223p_risons
prologs103512133p_rologs
purlieus1034633purlieus
querulous1842813querulous
resinous838503resinous
rimous8311913__rimous
sedulous946133sedulous
sepalous1047523sepalous
sericeous1146343sericeous
serous65023563ser__ous
setulous846913setulous
specious1247483speci_ous
spermous1247933sper_mous
spiritous1155023spiritous
spurious1036963spuri_ous
tedious838443tedi_ous
tendrilous1152623tendrilous
urinous7310083_urinous
variolous1244983variolous
various103113103vari_ous
venulous1145713venulous
verminous1445573verminous
zealous1637813ze_alous

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.453394461.4
2DLD Change Limit1461621307.58019282.6
3Display Results1301300.0462826.1
 (SQL Overall)1786911308.07922118.0
 
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.