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

106 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
pyralid134798(None) 
pyralids1445811pyralids
pyramid1547511pyramid
peracid12312992peracid
pyralidid1653642pyralidid
pyramids1645642pyramids
pyranoid1447282pyranoid
afraid1049723afra_id
aramid93315613_aramid
bipyramid1952093bipyramid
braid85822263_bra_id
byrled12437173byr_led
carabid12311333carabid
cyanid123912043cy_anid
eyelid1038443ey_elid
gravid113710983_gravid
gyral94412783gyral__
gyrally1435583gyrally
gyrated12428413gyrated
halid94424983__halid
herald10311343heral_d
hyalin122210043hy_alin
hyaloid1439073hy_aloid
hydatid1546523hydatid
hydracid1844983hydracid
hyracoid1745973hyracoid
invalid1146393invalid
lyrated11388473lyrated
muraled10410833muraled
oorali6311263oorali_
ooralis7312553ooralis
ozalid1696683_ozalid
paid75737493p__a_id
paled85538723p__aled
pallid93915293p_allid
paraded114014263paraded
paraglide1345703paraglide
paranoid11311143paranoid
parled94626293par_led
paroled104217633paroled
parotid102915513parotid
parslied1137823parslied
pavid115717003p__avid
pealed95322813p_ealed
pearled10411553pearled
pedaled113711893pedaled
peracids13310073peracids
percoid12312323percoid
periled10316323periled
peroxid17310283peroxid
petaled103614153petaled
petaloid1148753petaloid
phrased1387383phrased
pirated102515613pirated
piratic11314293piratic
placid114012543p_lacid
plaid85118303p_la_id
portaled11239203portaled
praline93019743p_raline
prated94924923p_rated
praxis154012253p_raxis
prayed124815433p_rayed
prebid113512843p_rebid
prelim10311433p_relim
prolix1538683p_rolix
psyllid1344523psyllid
ptyalin1274783ptyalin
puranic11410483puranic
purblind1345163purblind
purfled13248733purfled
purled94520753pur_led
purlin83615863pur_lin
purpled12299783purpled
pygmoid1644533pygmoid
pyoid11513763py__oid
pyralidids1752143pyralidids
pyramidal1744013pyramidal
pyramided1873833pyramided
pyramidic1943773pyramidic
pyran10514473pyra__n
pyrans11411063pyra_ns
pyrenoid1446873pyrenoid
pyretic143210783pyretic
pyrexia19225463pyrexia
pyrexic21235353pyrexic
pyric123815073pyr__ic
pyridic15267833pyridic
pyritic143311313pyritic
pyrola1139003pyrol_a
pyrolas1239863pyrolas
pyrolize2248133pyrolize
pyrolized2446123pyrolized
pyrosis12411653pyrosis
pyrrhic1744073pyrrhic
pyrrolic1544563pyrrolic
rabid84520783__rabid
raid55243083__ra_id
ranid66429333__ranid
rapid86422033__rapid
sialid7314943_sialid
spiraled1137733spiraled
squalid1737053squalid
syrphid1646103syrphid
upbraid1244973upbra_id
valid94618393__valid
yald86920613_y_al_d

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271067.67317467.4
3Display Results1061060.0303533.3
 (SQL Overall)1786911068.12621990.0
 
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.