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 “peril” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
peril7542595(None) 
peri65636971peri_
perils84121851perils
peris75537071peris
aerial64625712aerial
aerie54634602aerie
aerily93017012aerily
aril45843022_aril
beryl101211672beryl
bezil163812882bezil
ceil65725062ce_il
ceria75125352ceria
ceric94023092ceric
deil56231622de_il
derail74218812derail
devil94714732devil
eerie55228532eerie
eerily92913562eerily
ervil8310302_ervil
evil75318072_evil
feral85424652feral
feria85922712feria
ferial94621252ferial
gerbil938342gerbil
heil76328932he_il
herl75834552her_l
imperil1147682imperil
jerid132316422jerid
kevil12399862kevil
merit7339182merit
merl65830972mer_l
nerol51017812nerol
pail66141832p_ail
paris75145942paris
parol74826272parol
peal68648102pe_al
pearl75324462pearl
pedal86022502pedal
peel65535612pe_el
peerie83617892peerie
pein65834942pe_in
pekin111514422pekin
penal75228372penal
pencil103712972pencil
penial84120892penial
penile82219602penile
penis75129322penis
pensil83013332pensil
per56353092per__
perch124518832perch
perdie94718512perdie
perdu84216272perdu
perdy115417322perdy
pere66450262per_e
perea75026442perea
pereia85217982pereia
peres76246642peres
periled10316312periled
perilla9311222perilla
period9314982period
perish114619062perish
periti8319952periti
perk106232842per_k
perkily1637802perkily
perks115325802perks
perky145319482perky
perm85834632per_m
permit10321682permit
perms95524512perms
pernio8513142pernio
perp89029892per_p
perps95521482perps
perry105222712perry
perse75429522perse
pert66759322per_t
pertly115312542pertly
perv97224812per_v
pervs105117372pervs
petal76526892petal
petit74332652petit
petrel83111532petrel
petrol82714062petrol
pewit104622792pewit
prig75924872p_rig
prill74117942p_rill
prim85132202p_rim
pterin81014152pterin
puerile9310092puerile
pupil94712982pupil
puri65931442puri_
purin75527592purin
puris75332022puris
purl65631422pur_l
pyric123815072pyric
reoil55321182reoil
rerig64018482rerig
serail64222672serail
seral56336382seral
serial64625862serial
serif84132132serif
serin55434442serin
speil75618642spe_il
veil75523592ve_il
verily122616052verily
vexil1538962vexil
xeric144315662xeric
zoril143916692zoril

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001071.62633087.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911071.749102167.5
 
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.