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 “pervious” 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
pervious133754(None) 
previous1337821previous
devious1138522de_vious
envious1037222_envious
impervious1752962impervious
nervous1037142nerv_ous
pereions10310852pereions
perilous10310692perilous
periods10312242per_iods
peritus9311802per_itus
pluvious1344442pluvious
precious12310592precious
serious73616282ser_ious
carious93320283car_ious
cernuous1055013cernuous
cerous85821203cer__ous
cervices1537133cervices
cervixes2054603cervixes
curious93813563cur_ious
ervils948773_ervi_ls
fermions1336203fermions
ferocious1445193ferocious
ferreous1146043ferreous
ferrous1049803fer_rous
fervors1336233ferv_ors
fervour1343103ferv_our
fervours1453053ferv_ours
furious103110633fur_ious
heriots10312063her_iots
imperious1346583imper_ious
nervines112310463nervines
nervings12256323nervings
obvious1244823_obvious
parlous9414293par_lous
parous84024163par__ous
parvenus1335653parvenus
parvis116114803parvi__s
parvises133911913parvises
parvos116614753parv_o_s
paviors1237603p_aviors
paviour1244623p_aviour
paviours1343613p_aviours
peavies122213403peavi_es
pectinous1345553pectinous
pelvics14245643pelvi_cs
pelvis113610323pelvi__s
pelvises1337273pelvises
pensions10311693pensions
penurious1145823penurious
percoids1339663percoids
perdus93711273per__dus
pereion9312053pereio_n
pereons92815003per_eons
perfidious1653673perfidious
peridots1138323peridots
perigons11310083perigons
perils84121853per_i_ls
period9314983per_io_d
perique1837523per_ique
periques1937653per_iques
peris75537073per_i__s
perjurious1952843perjurious
perlites10316363perlites
permits11314003permi_ts
pernicious1445503pernicious
pernio8513143pernio__
perniones1148593perniones
pernods1038483per_nods
perries93226603perri_es
perrons93115483per_rons
persists1049183persists
persons93717013per_sons
pervades1437353pervades
pervasions1545663pervasions
perverts1337533perverts
pervs105117373perv___s
petalous1058973petalous
petrous92714423pe_trous
pious74621273p___ious
porous84419483por__ous
portions10514413portions
poxvirus2041883poxvirus
previews1634513previews
previously1885863previously
previses133814283previses
previsors14126483previsors
primus103712173p_r_imus
prions84317783p_r_ions
priors83914483p_r_iors
provirus1345453provirus
pulvinus1343263pulvinus
purlieus1034633purlieus
purviews1642533purviews
pyritous1344933pyritous
reovirus1143423reovirus
serous65023563ser__ous
services1338573services
servings12249223servings
servitors1245213servitors
servos93812723serv_o_s
specious1247483spe_cious
spermous1247933sper_mous
spurious1036963spur_ious
tedious838443te_dious
terminus1037393terminus
ternions838813ternions
tortious839023tortious
unenvious1263243unenvious
various103113103var_ious
veracious1447123veracious
verminous1445573verminous
versions11310353versions

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621126.98320931.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.43524033.8
 
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.