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

133 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
peridot1051424(None) 
peridots1138321peridots
heriot9422342heri_ot
periapt11313412periapt
peridia10312362peridia
peridotic1446482peridotic
perigon1039852perigon
period9314982peri_od
periods10312242periods
preriot9316412preri_ot
aeriest73924053aeriest
aperient10715153aperient
apricot111010183apricot
deride84420033derid_e
derided102914253derided
derider93214973derider
derides93420853derides
eeriest73620673eeriest
eidos65817753_e_idos
epidote1037393_epidote
ergot65422893_er_got
griot65328413_gri_ot
gueridon1043033gueridon
haricot12311963haricot
heirdom1344493heirdom
heriots10312063heri_ots
heritor10310563heritor
jerid132316423jerid__
jerids142810943jerid_s
lepidote1144683lepidote
melilot9311083melilot
merino8315093merino_
merinos9311983merinos
merit7339183meri__t
merlot83217603mer_lot
parador103311413parador
parados103816053parados
paradox17358173paradox
pardon94618733par_don
parodoi10267723parodoi
parodos103011753parodos
parrot8320663par_rot
patriot9314533patri_ot
pepino10310333pepino_
pepinos1137693pepinos
percent113520603percent
percept133112523percept
perdie94718513per_die
perdu84216273per_d_u
perdue93912633per_due
perdus93711273per_dus
perdy115417333per_d_y
pereion9312053pereion
pereon83517453per_eon
perfect141010833perfect
perfidy1635273perfid_y
peri65636973peri___
perianth1348553perianth
periapts1237273periapts
pericope1447783pericope
periderm1346803periderm
peridial11411923peridial
peridium1349023peridium
peridotite1354923peridotite
perigee101113393perigee
perigons11310083perigons
peril75425953peri__l
periled10316323periled
perilla9311233perilla
perilous10310693perilous
perils84121853peri_ls
perinea9313033perinea
periodate1248343periodate
periodic1348433periodic
periodid1248163periodid
periotic12313443peri_otic
peripety1546193peripety
perique1837523perique
peris75537073peri__s
perish114619063peri_sh
periti8319953peri_ti
peritus9311803peritus
periwig1345163periwig
perkiest143313243perkiest
permit10321683per_mit
pernio8513143pernio_
pernod9310453per_nod
pernods1038483pernods
perpent112318813perpent
perron83216623per_ron
persalt9315413persalt
persist9315853persist
person83517873per_son
pert66759323per___t
pertest9317043pertest
pervert12315583pervert
petit74332653peti__t
pewit104622793pewi__t
picot95031013p__icot
pierrot948833pier_rot
pilot77435063p__ilot
pinot78737293p__inot
pivot106523873p__ivot
preadopt1348313preadopt
predict12315323predict
preedit10512463preedit
pride84724733p_rid_e
prided103618033p_rided
prides94324183p_rides
priest84125423p_riest
primo95017913p_rimo_
primos104514423p_rimos
print74837463p_ri_nt
prion75119993p_ri_on
prior74316173p_ri_or
prison8514023p_rison
privet113821343p_rivet
prutot8311823p_rutot
purist85525053puri_st
pyridic15267833pyridic
reredos838633reredos
riot45947213__ri_ot
serfdom1344213serfdom
stridor8467393stridor
teredo7310783teredo_
teredos839183teredos
tricot8317753_tricot
verdict1339583verdict
veridic1338143veridic
veriest103719133veriest
verist93823893veri_st
weirdo10405883weirdo_
weirdos11355123weirdos

Search took 7 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.420425454.8
2DLD Change Limit1340271336.19021652.2
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.65626846.6
 
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.