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

110 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
perfidy163527(None) 
perdy115417332per__dy
perfumy1763932perfumy
perkily1637812perkily
aerify122810113aer_ify
aerily93017013aer_ily
beefily1535613beefily
certify1546243certify
cervid1239323cervid_
deride84420033der_ide
eerily92913563eer_ily
effigy1642213_effigy
ferity122813343fer_ity
fervid1337513fervid_
fervidly1863323fervidly
jerid132316423jer_id_
jerids142810943jer_ids
jerkily2134623jerkily
jerrid14259143jerrid_
jerrids15277743jerrids
kerfed14358233kerfed_
kerfing15307533kerfing
merrily1238633merrily
nerdy95014703ner__dy
nereid7312923nereid_
nereids838743nereids
nervily1336863nervily
pardy115523953par__dy
parity114719873par_ity
parody12410093par_ody
peppily1335133peppily
peptid112712373peptid_
peptide122910683peptide
peptids12239323peptids
peracid12312993peracid_
peracids13310073peracids
percoid12312313percoid_
percoids1339663percoids
perdie94718513perdi_e
perdu84216273per__du
pereia85217983perei_a
pereion9312053pereion
perfect141010833perfect
perfidies1546603perfidies
perform1439283perform
perfume1446503perfume
perfuse1247663perfuse
peri65636973per_i__
peridia10312363per_idia
peridot10514243per_idot
peril75425953per_i_l
perils84121853per_ils
period9314983per_iod
periods10312243periods
peris75537073per_i_s
perish114619063per_ish
periti8319953per_iti
perjury19244253perjury
perked134617693perked_
perkier133813123perkier
perking143716463perking
perkish16258823perkish
perky145319483per__ky
perlite9317323perlite
permed115217353permed_
permian112612283permian
perming123416093perming
permit10321683permi_t
permits11314003permits
pernio8513143perni_o
pernod9310453pernod_
pernods1038483pernods
peroxid17310273peroxid_
peroxide1848183peroxide
peroxids1837453peroxids
peroxy1838253per_oxy
perries93226603perries
perry105222713per__ry
persist9315853persist
perspiry1543783perspiry
pertly115312553per_tly
pervade1337023pervade
peskily1635083peskily
petrify1536573petrify
pettily1238173pettily
ploidy1237483p_loidy
porridgy1542133porridgy
prebid113512843prebid_
prebids12399883prebids
prefade1339013prefade
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
preside10715613preside
pricy124814563p_r_icy
pride84724733p_r_ide
privy13439833p_r_ivy
puffily1834843puffily
purify14399153pur_ify
purity114114913pur_ity
pursily1238213pursily
serfish1348973serfish
terrify1336353terrify
verbid122311313verbid_
verbids13259203verbids
verbify1834993verbify
verify153110163ver_ify
verily122616053ver_ily
verity123714853ver_ity
versify1636333versify

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271106.94019312.2
3Display Results1101100.0303666.7
 (SQL Overall)1786911107.37324235.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.