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

116 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
peridots113832(None) 
peridot10514241peridot_
heriots10312062heri_ots
periapts1237272periapts
peridotic1446482peridotic
perigons11310082perigons
perilous10310692perilous
periods10312242peri_ods
aperients1178253aperients
apricots1275393apricots
deriders102411853deriders
derides93420853derid_es
eidos65817753_e_ido_s
epidote1037393_epidote
epidotes1147023_epidotes
ergots74512373_er_gots
griots74713643_gri_ots
gueridons1142803gueridons
haricots1347333haricots
heirdoms1444353heirdoms
heriot9422343heri_ot_
heritors11310903heritors
jerids142810943jerid__s
lepidote1144683lepidote
lepidotes1244303lepidotes
melilots1046553melilots
merinos9311983merino_s
merits8320873meri__ts
merlots92710123mer_lots
paradors113411903paradors
parados103816053parado_s
pardons103817623par_dons
parodos103011753parodo_s
parrots9312743par_rots
patriots1038053patri_ots
pepinos1137693pepino_s
percents122713373percents
percepts14247643percepts
perdues103511333per_dues
perdus93711273per_d_us
pereions10310853pereions
pereons92815003per_eons
perfects15107353perfects
perfidies1546603perfidies
perfidious1653673perfidious
perianth1348553perianth
perianths1445473perianths
periapt11313413periapt_
pericope1447783pericope
pericopes1547873pericopes
periderm1346803periderm
periderms1444993periderms
peridia10312363perid_ia
peridial11411923peridial
peridium1349023peridium
peridotite1354923peridotite
peridotites1454263peridotites
perigees1189503perigees
perigon1039853perigo_n
perillas10310823perillas
perils84121853peri__ls
period9314983peri_o_d
periodate1248343periodate
periodates1347863periodates
periodic1348433periodic
periodid1248163periodid
periodids1345643periodids
periotic12313443peri_otic
peripatus1344933peripatus
peripety1546193peripety
periques1937653periques
peris75537073peri___s
perishes13313753perishes
periti8319953peri__ti
peritus9311803peri_tus
periwigs1444193periwigs
permits11314003per_mits
pernods1038483per_nods
perpents122312043perpents
perrons93115483per_rons
persalts1038193persalts
persists1049183persists
persons93717013per_sons
perverts1337533perverts
pervious1337543pervious
pewits112810683pewi__ts
picots104616443p__icots
pierrots1044963pier_rots
pilots84018873p__ilots
pinots85920273p__inots
pivots115111903p__ivots
preadopts1445143preadopts
predicts1339613predicts
preedits1168763preedits
preriot9316413preri_ot_
prides94324183p_rid_es
priests93810863p_riests
primos104514423p_rimo_s
prints84320103p_ri_nts
prions84317783p_ri_ons
priors83914483p_ri_ors
prisons9313223p_risons
privets122910053p_rivets
purists94014073puri_sts
pyritous1344933pyritous
reredos838633reredo_s
riots54922013__ri_ots
serfdoms1443763serfdoms
serious73616283seri_ous
stridors9367323stridors
teredos839183teredo_s
tricots9311563_tricots
verdicts1446013verdicts
verists103613673veri_sts
weirdoes12323843weirdoes
weirdos11355123weirdo_s

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.420425454.8
2DLD Change Limit1461621167.39319770.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.85922737.1
 
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.