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

124 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
percoids133966(None) 
percoid12312311percoid_
dermoids1246162dermoids
peracids13310072peracids
periodids1345642periodids
periods10312242perio_ds
pernods1038482perno_ds
peroxids1837442peroxids
placoids1347342placoids
sarcoids1137802sarcoids
aneroids9310203aner_oids
aroids75118223_ar_oids
becrowds1683773becrowds
ceboids1237653ce_boids
cercis104614493cerc_i_s
cestoids11308273cestoids
coccoids12176793coccoids
coracoids1445833coracoids
cricoids1347183cricoids
deltoids1045483deltoids
dermoid1138523dermoid_
desmoids1244973desmoids
discoids1239873discoids
droids84712583_dr_oids
emeroids11147723emer_oids
ericoid1049893_ericoid_
fucoids1335663_fucoids
geoids8369843ge__oids
helicoids1544973helicoids
heroics122912003her_oics
heroins103518013her_oins
hyracoids1844253hyracoids
jerids142810943jer__ids
jerrids15277743jer_rids
keloids1288663ke_loids
lentoids947443lentoids
meloids10911453me_loids
mercies113817563merc_ies
mermaids1355753mermaids
mucoids1237423_mucoids
negroids10116323negroids
nereids838743ner_eids
orchids1377213_orchids
paranoids1248913paranoids
parboils1237433parboils
parotids112610413parotids
parotoids1256953parotoids
peacoats1247833peacoats
peacocks1844993peacocks
pearwoods1544543pearwoods
peascods1344063peasco_ds
pectins112315233pe_ctins
pencils113011773penc_ils
peptids12239323pe_ptids
peracid12312993peracid_
percales12313803percales
perceive1546973perceive
perceives1646313perceives
percents122713373percents
percepts14247643percepts
perched154713233perched_
perchers153611523perchers
perches143717953perc_hes
perching163711633perching
percuss1137163perc_uss
pereions10310853pereions
pereons92815003pereo_ns
pereopods1444233pereopods
perfidy1635263per_fidy
performs1547483performs
pergolas1158233pergolas
pericopes1547873pericopes
perils84121853per__ils
period9314983perio_d_
periodic1348433periodic
periodid1248163periodid
peris75537073per__i_s
periwigs1444193periwigs
permits11314003per_mits
pernod9310453perno_d_
peroxid17310263peroxid_
peroxide1848173peroxide
peroxides1947483peroxides
perpends13227743perpends
perries93226603per_ries
perrons93115483perro_ns
personas102511883personas
persons93717013perso_ns
pertains102113423pertains
pervious1337543pervious
petcocks1844583petcocks
placoid1239773placoid_
prebids12399883p_rebids
preboils1267293preboils
precious12310593precious
precis103416703prec_i_s
precode12311853preco_de
precodes13711573precodes
precooks1656763precooks
precools1237703precools
preloads1157513preloads
premolds1345843premolds
prerecords1542783prerecords
procercoids1852133procercoids
prods85523553p_r_o_ds
psocids1234863psoc_ids
pterygoids1761593pterygoids
purloins1077033purloins
pyralids1445813pyralids
pyramids1645643pyramids
pyrenoids1544803pyrenoids
recoils93814873re_coils
recoins94019243re_coins
records105213923re_cords
rerecords1244003rerecords
sarcoid10310453sarcoid_
seconds1038283se_conds
sparoids11218713spar_oids
spheroids1545543spher_oids
steroids9911443ster_oids
supercoils1487493supercoils
toroids8310643tor_oids
verbids13259203ver_bids
viroids1137923vir_oids

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.1561145455.1
2DLD Change Limit1461621247.03320782.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.23524698.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.