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 “pyres” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

235 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
pyres10552388(None) 
byres104421381byres
eyres84921771eyres
gyres94820321gyres
lyres85019961lyres
pares77164481pares
peres76246641peres
pores75849031pores
pyes95528991py_es
pyre94925551pyre_
pyrex175211211pyrex
pyros105718291pyros
pyxes175911401pyxes
tyres84725231tyres
acres76327762acres
apres75426402apres
ares45871022_ares
aures55137092aures
ayes76543512ay_es
bares75457132bares
bores76448252bores
byes95230532by_es
byre95023852byre_
byrls105711232byrls
bytes105217492bytes
cares77369182cares
ceres75540012ceres
cires74932912cires
cores76361852cores
cures75645432cures
cymes1210118922cymes
cypres1338522cypres
dares66146702dares
dures65635922dures
dyers96617132dyers
dyes85331892dy_es
dykes135215572dykes
dynes95917582dynes
eyers86521332eyers
eyes75837882ey_es
eyras84715922eyras
eyre75525252eyre_
eyries93816812eyries
fares85852872fares
feres86038182feres
fires85740752fires
fores85847102fores
fyces139813642fyces
fykes156312692fykes
gores65740372gores
gybes115012722gybes
gyre84722762gyre_
gyred105114092gyred
gyros95616482gyros
gyrus95310802gyrus
gyves125711552gyves
hares86255542hares
heres86245902heres
hires86134342hires
hypes135818672hypes
ires45639282_ires
kyes115124932ky_es
kyries133411372kyries
kytes125012912kytes
lares54852632lares
lores55045402lores
lures56138532lures
lyes75530832ly_es
lyre75623792lyre_
lyses84518252lyses
mares76457632mares
meres75143572meres
mires75640882mires
mores76249642mores
mures75937212mures
nares55544152nares
ogres65818632ogres
ores46056682_ores
oyers87620882oyers
oyes74940132oy_es
paces96741112paces
padres95016982padres
pages85235072pages
pales75753802pales
panes76148692panes
paras76143042paras
pards85634332pards
pare66760842pare_
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
parers85530742parers
pareu74928742pareu
pareus85420742pareus
parges94529542parges
paries84742512paries
paris75145942paris
parks116134462parks
parles86334392parles
parrs75928672parrs
pars67560792par_s
parse75236992parse
parses85534702parses
parts77743372parts
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
payees114812902payees
payers114621822payers
pedes85327282pedes
peers75130272peers
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penes75839222penes
pere66450262pere_
perea75026442perea
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pes57259782p__es
physes14399782physes
piers75926332piers
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pirns76020092pirns
pixes144323172pixes
plies74526512plies
plyers114912982plyers
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
poxes145325722poxes
pree67044732p_ree
prees75937172prees
prep86427672p_rep
preps96220692p_reps
presa74319042p_resa
prese75228382p_rese
press75425952p_ress
prest75736352p_rest
prex135722972p_rex
prey96228482p_rey
preys105717782p_reys
prez156126312p_rez
pries74339532pries
pros65742782p_ros
pryer104415312pryer
pryers115012242pryers
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pure65543332pure_
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purges94421762purges
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
purse76028892purse
purses84826372purses
puses75532202puses
pyas96225702py_as
pye86432502py_e_
pyins105815862pyins
pyoses114314302pyoses
pyran10514472pyran
pyrans11411062pyrans
pyrene113210732pyrene
pyrenes123511222pyrenes
pyrexes19305832pyrexes
pyric123815072pyric
pyrites12812202pyrites
pyro96019392pyr_o
pyrones123113302pyrones
pyropes142210192pyropes
pyxies18338292pyxies
pyxis17458632pyxis
rares55247442rares
res35565042__res
ryes75529352ry_es
rykes125513032rykes
seres55448892seres
sires55945372sires
sores55454282sores
spares84834552spares
spires84628112spires
spores84726612spores
syces106416462syces
sykes124816862sykes
syren85216742syren
syrens94911992syrens
tares57456562tares
tires55437492tires
tores55352672tores
tres46542902_tres
tyees86019452tyees
tyers86220052tyers
tyes76433372ty_es
tykes125817062tykes
tynes85920302tynes
types105721062types
tyre75428252tyre_
tyred95816432tyred
tyros85118592tyros
vires84529682vires
wares88250582wares
wires86034912wires
wyes105727502wy_es
wyles114615322wyles
wytes114113432wytes
yes66250612_y_es
yores85031322yores
zymes1924712942zymes

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002352.06326078.5
3Display Results2352350.0603916.7
 (SQL Overall)1786912352.21680636.7
 
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.