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

122 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
pervading163630(None) 
evading1237282_e_vading
parading12313862par_ading
persuading1454502persuading
prefading16149032prefading
rereading111212712rereading
abrading1239503abr_ading
aerating92821003aer_ating
arcading1239763_arcading
beading113221863be__ading
beheading1636163beheading
beraking153612973ber_aking
berating113220763ber_ating
bereaving1537573bereaving
breading123515463_breading
corrading1338203corrading
degrading13137373degrading
deleading1237773deleading
derating103222283der_ating
deriding112512933der_iding
dreading113712803_dreading
enervating1488433enervating
erasing8317963_er_asing
eroding9314273_er_oding
grading103918713_gr_ading
heading122919113he__ading
heralding1435773heralding
herding122915123her__ding
invading1336263_invading
leading93419553le__ading
nerving112910833nerv__ing
operating12313723oper_ating
overlading1539323overlading
parawing14310583par_awing
parbaking1877203parbaking
parlaying1537303parlaying
partaking1698673partaking
peacing124117073pe__acing
peaking144317693pe__aking
pealing104123203pe__aling
pedaling122412133pe_daling
peeving135112243peev__ing
pending114119773pe__nding
percaline13410953percaline
perching163711633per_ching
perduring1336013perduring
perfuming1784053perfuming
perfusing1565633perfusing
periling11316863per_iling
perilling12410003perilling
perishing1539533perishing
perjuring1944923perjuring
perking143716463per__king
permeating1539923permeating
perming123416093per__ming
permuting1446553permuting
perorating13313133perorating
peroxiding2144933peroxiding
perpending1646683perpending
pertain92714963perta_in_
pertaining1347993pertaining
pertains102113423perta_ins
perusing11811063per_using
pervade1337023pervad__e
pervaded1535373pervad_ed
pervader1444863pervad_er
pervaders1544433pervaders
pervades1437353pervad_es
pervasion1446073pervasion
pervasions1545663pervasions
pervasive1744483pervasive
perverting1646623perverting
petnaping1444543petnaping
phrasing1438013phr_asing
phreaking1936473phreaking
pirating11314513pir_ating
pleading123011443p_leading
pomading1437423p_omading
portaging1346843portaging
prating103424453p_r_ating
praying133717323p_r_aying
prebaking1838063prebaking
preceding15129363preceding
precoding15109733precoding
predating13514653predating
prefacing17118743prefacing
preloading1446583preloading
preluding1337053preluding
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
presaging1339393presaging
presiding13510903presiding
pretaping1439133pretaping
prevailing1656723prevailing
prevaluing1644273prevaluing
prevising15510873prevising
prevuing1457253prev_uing
priding113317543p_r_iding
prodding13189343p_rodding
providing1637963providing
purveying1843573purveying
reading93327213__reading
regrading121210203regrading
reinvading1543823reinvading
reloading1189883reloading
rereadings12124543rereadings
respading1338803respading
retreading12128483retreading
serenading1246103serenading
seriating10916403seriating
serrating10513213serrating
servicing1545343servicing
serving113014983serv__ing
spreading1339653spreading
terracing1237703terracing
threading14107593threading
trading93517973_tr_ading
treading103515333_treading
upgrading1444903upgr_ading
vervain1335563verva_in_
vervains1435293verva_ins

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.436409841.7
2DLD Change Limit1486411227.32620289.5
3Display Results1221220.0502440.0
 (SQL Overall)1786911227.81222873.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.