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

166 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
perigons1131008(None) 
perigon1039851perigon_
epigons1048182_epigons
paragons11311502paragons
pereions10310852pereions
pereons92815002per_eons
peridots1138322peridots
perigees1189492perigees
perigyny1742912perigyny
perilous10310682perilous
periods10312242peri_ods
perrons93115482per_rons
persons93717002per_sons
prions84317782p_ri_ons
prisons9313222p_risons
trigons84312092_trigons
aerugos834923aerugo_s
argons75018203_ar_gons
benisons1037043benisons
decagons1235893decagons
deigns8389983de_ig_ns
demigods1343983demigods
deraigns1034873deraig_ns
derisions1038843derisions
designs9328313desig_ns
dragons938383_dragons
durions839963duri_ons
eikons1038503_e_ikons
epigon937963_epigon_
epigone1057843_epigone
epigones1138023_epigones
epigoni1056093_epigoni
epigonus1144423_epigonus
epsilons1044223epsilons
ergots74512373_er_gots
erigerons1044903_erigerons
eringoes937433_eringoes
eringos836913_eringo_s
erugos7347343_erugo_s
feigns10407753fe_ig_ns
fermions1336203fermions
gorgons938853gor_gons
grisons838993_grisons
gueridons1142803gueridons
helicons1337613helicons
heriots10312063heri_ots
heritors11310903heritors
herons94820543her__ons
hexagons1943943hexagons
horizons2045463horizons
jargons1558203jar_gons
kerogens1345763kerogens
legions84611783legi_ons
lesions73813863lesi_ons
lexicons1743893lexicons
lyricons1343583lyricons
merinos9311973merino_s
merlons93311273mer_lons
morions94014633mori_ons
operons91411743oper__ons
origans839973_origans
origins8310463_origins
orisons7310563_orisons
paragon10311023paragon_
pardons103817623par_dons
pargos95719043par_go_s
parians93519733pari_ans
parsons93516873par_sons
partons94620513par_tons
pedagogs13123793pedagogs
peins76128063pe_i__ns
pekins121812233peki__ns
pelicans1238093pelicans
pelotons1038913pelotons
pemicans1447033pemicans
pendragons1452243pendragons
pengos94612413pe_ngo_s
pennons939713pe_nnons
pensions10311693pensions
pentagons1246153pentagons
peons75327183pe___ons
pepinos1137693pepino_s
perditions1348863perditions
peregrins1246963peregrins
pereion9312043pereion_
pereon83517453per_eon_
pergola1067623per_gola
pergolas1158233per_golas
periapts1237273periapts
pericope1447783pericope
pericopes1547873pericopes
peridot10514243perido_t
perigeal1147543perigeal
perigean1146353perigean
perigee101113383perig_ee
perigynies1643963perigynies
perigynous1653013perigynous
periling11316863periling
perillas10310813perillas
perils84121853peri__ls
perilune1046973perilune
perilunes1147143perilunes
period9314983peri_o_d
periques1937653periques
peris75537073peri___s
perishes13313753perishes
peritonea1147303peritonea
peritus9311803peri_tus
periwigs1444193periwigs
perniones1148593perniones
pernods1038483per_nods
perron83216623per_ron_
persimmons1652053persimmons
person83517873per_son_
persona92812443per_sona
personas102511873per_sonas
pertains102113413pertains
pervious1337543pervious
petitions11511083petitions
pigeons1039183p__igeons
pinions93413603pini_ons
pinons86019943p__inons
pions75826393p__i_ons
pitons85319043p__itons
poisons9310353p_oisons
polygons1447723polygons
portions10514393portions
potions93417423poti_ons
prigs85219703p_rig__s
primos104514423p_rimo_s
prion75119993p_ri_on_
priors83914483p_ri_ors
prison8514023p_rison_
protons93118003p_rotons
prurigos1142363prurigo_s
pterins9812993pteri__ns
purins83722653puri__ns
puritans1037633puritans
pyritous1344933pyritous
pyrogens1437293pyrogens
regions83613473regi_ons
reigns74811753re_ig_ns
religions1086603religions
rerigs74014793rerig__s
resigns83910963resig_ns
rigors72813713__rigors
sericins10312463sericins
serins64029673seri__ns
serious73616273seri_ous
sermons9311783ser_mons
serpigoes1243783serpigoes
serpigos1143843serpigo_s
ternions838813ternions
tetragons1045333tetragons
tigons74112253__tigons
trigon74513103_trigon_
trigos74214173_trigo_s
tritons73814883_tritons
trogons83410713_trogons
turions7311573turi_ons
venisons1136133venisons
versions11310353versions
vertigoes1354693vertigoes
vertigos1254973vertigo_s
virions1039873viri_ons
warisons1136903warisons

Search took 10 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.1731032896.0
2DLD Change Limit1461621669.48615408.2
3Display Results1661660.0931784.9
 (SQL Overall)1786911669.75218323.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.