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

120 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
pyros10571829(None) 
gyros95616481gyros
pros65742781p_ros
pyres105523881pyres
pyro96019391pyro_
tyros85118591tyros
biros75325132biros
bros65635662_bros
byres104421382byres
byrls105711232byrls
ceros74726072ceros
duros65422692duros
eros45238452_eros
euros54920242euros
eyras84715922eyras
eyres84921772eyres
faros85532022faros
giros65722652giros
gyres94820322gyres
gyro85217882gyro_
gyron95314622gyron
gyrons105511222gyrons
gyrose105310252gyrose
gyrus95310802gyrus
heros84930862heros
hydros13279362hydros
hypos1312014742hypos
lyres85019962lyres
paras76143042paras
pards85634332pards
pareos87023772pareos
pares77164482pares
pargos95719042pargos
paris75145942paris
parks116134462parks
parol74826272parol
parols84722612parols
parous84024162parous
parrs75928672parrs
pars67560792par_s
parts77743372parts
parvos116614752parvos
payors114312642payors
pedros9312182pedros
pepos96620082pepos
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pesos77221622pesos
pharos11312062pharos
pirns76020092pirns
pirog83913672pirog
pisos76021062pisos
polos76129912polos
pomos95321582pomos
poos65949112p_oos
pores75849032pores
porks115124142porks
pornos85015252pornos
porns75527342porns
porose84818742porose
porous84419482porous
ports75934592ports
praos74923562praos
pro55837262p_ro_
proa66229962p_roa
proas75028802p_roas
prod76129502p_rod
prods85523552p_rods
prof96134662p_rof
profs105120892p_rofs
prog75729002p_rog
progs86624152p_rogs
prom87631702p_rom
proms95426412p_roms
prop85932812p_rop
props95726882p_rops
prose75835122p_rose
proso77222412p_roso
pross76529402p_ross
prost75434102p_rost
prosy106319252p_rosy
prow97030382p_row
prows106327012p_rows
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
pyas96225702py_as
pyes95528992py_es
pyins105815862pyins
pylon103614002pylon
pylons113011242pylons
pyran10514472pyran
pyrans11411062pyrans
pyre94925552pyr_e
pyrex175211212pyrex
pyric123815072pyric
pyrola1139002pyrola
pyrolas1239862pyrolas
pyrone112714472pyrone
pyrones123113302pyrones
pyrope132810532pyrope
pyropes142210192pyropes
pyrosis12411652pyrosis
pyrrol1136272pyrrol
pyrrols1235402pyrrols
pyxes175911402pyxes
pyxis17458632pyxis
saros55238062saros
taros55640822taros
tiros54524892tiros
toros54336192toros
typos106015812typos
tyres84725232tyres
tyro76622362tyro_
zeros144918112zeros

Search took 2 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.310576422.6
2DLD Change Limit538001201.56334421.0
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.90693751.8
 
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.