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

176 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
percoid1231232(None) 
percoids1339661percoids
dermoid1138522dermoid
ericoid1049892_ericoid
peracid12312992peracid
perched154713242perched
period9314982perio_d
periodid1248162periodid
pernod9310452perno_d
peroxid17310282peroxid
placoid1239772placoid
sarcoid10310452sarcoid
aneroid8314013aner_oid
aroid65428343_ar_oid
becrowd1555183becrowd
ceboid11310653ce_boid
ceratoid1149923ceratoid
cerci93716393cerc_i_
cercis104614493cerc_is
cervid1239323cer_vid
cestoid104011673cestoid
cirsoid1038123cirsoid
coccoid11299283coccoid
coracoid1348163coracoid
cormoid12310403cormoid
cricoid1239253cricoid
deltoid938573deltoid
dentoid9310663dentoid
dermoids1246163dermoids
desmoid1137103desmoid
devoid1189363de_void
discoid11311243discoid
droid74218543_dr_oid
emeroid101511183emer_oid
fervid1337513fer_vid
fucoid1237893_fucoid
geoid74215763ge__oid
helicoid1446753helicoid
hemoid12313513he_moid
heroic113516923her_oic
heroin94420593her_oin
hyracoid1745973hyracoid
jerid132316423jer__id
jerrid14259143jer_rid
keloid11812623ke_loid
keratoid1347273keratoid
lentoid8310683lentoid
meloid9616003me_loid
mermaid1297853mermaid
mucoid1139783_mucoid
negroid9108903negroid
nereid7312933ner_eid
neuroid81110313neuroid
nevoid1098803ne_void
orchid1289573_orchid
overcold14208493overcold
paranoid11311143paranoid
parboil1138323parboil
parched154013693parched
parotid102915513parotid
parotoid11410033parotoid
peaced115818913peac_ed
peached154315883peached
peacoat11412913peacoat
peacock1745143peacock
pearwood1444833pearwood
peascod1244073peasco_d
peched144915343pe_ched
pecked155019103pe_cked
pectic122913873pe_ctic
pectin102615533pe_ctin
pencil103712973penc_il
peptid112712373pe_ptid
peracids13310073peracids
percale11314093percale
perceive1546973perceive
perceived1744353perceived
percent113520603percent
percept133112523percept
perch124518833perc__h
percher143313423percher
perches143717953perches
perching163711633perching
percuss1137163percuss
perdie94718513per_die
pereia85217983per_eia
pereion9312053pereion
pereon83517453pereo_n
pereons92815003pereons
pereopod1344933pereopod
perfidy1635273per_fidy
perform1439283perform
pergola1067623pergola
peri65636973per__i_
pericope1447783pericope
pericopic1745543pericopic
peridia10312373peridia
peril75425953per__il
periled10316323periled
periodic1348433periodic
periodids1345643periodids
periods10312243periods
periotic12313443periotic
peris75537073per__is
periti8319953periti_
periwig1345163periwig
perked134617693per_ked
permed115217353per_med
permit10321683per_mit
pernio8513143per_nio
pernods1038483pernods
peroxide1848193peroxide
peroxids1837453peroxids
peroxy1838253per_oxy
perpend12259353perpend
perron83216623perro_n
perrons93115483perrons
person83517873perso_n
persona92812453persona
persons93717013persons
pertain92714963pertain
peruked14367893peruked
perused103112203perused
petaloid1148753petaloid
petcock1744603petcock
phytoid1678753phytoid
pierced12347593pierc_ed
placid114012543plac_id
placoids1347343placoids
prebid113512843p_rebid
preboil1148953preboil
precis103416703prec_is
precode12311853precode
precoded1438863precoded
precook1577803precook
precool1139013precool
precoup1336123precoup
preload1049813preload
premold1247863premold
prepaid12310133prepaid
prerecord1444173prerecord
presold1059603presold
pretold1049083pretold
procercoid1752933procercoid
prod76129503p_r_o_d
proud84615483p_r_oud
psocid1137253psoc_id
pterygoid1652243pterygoid
purloin9107493purloin
pygmoid1644533pygmoid
pyoid11513763p__yoid
pyralid1347983pyralid
pyramid1547513pyramid
pyranoid1447283pyranoid
pyrenoid1446873pyrenoid
recoil84016723re_coil
recoin84320293re_coin
record96117433re_cord
rerecord1145373rerecord
sarcoids1137803sarcoids
second9411153se_cond
sparoid102311543spar_oid
spheroid1447283spher_oid
spiroid10219823spir_oid
sporoid102310733spor_oid
steroid81314873ster_oid
supercoil1357753supercoil
teratoid9411073teratoid
theroid11313403ther_oid
toroid7416013tor_oid
verbid122311313ver_bid
viroid10411523vir_oid
viscoid1337023viscoid
zebroid1936473zebroid
zeroed16409423zer_oed
zincoid1946663zincoid

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.390458182.1
2DLD Change Limit1340271767.34618244.9
3Display Results1761760.0602933.3
 (SQL Overall)1786911767.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.