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

121 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
pryer10441531(None) 
dryer95111461dryer
fryer115913431fryer
payer105125721payer
plyer106214331plyer
prayer114815291prayer
preyer114413731preyer
prier75027761prier
pryers115012241pryers
spryer11418531spryer
wryer11489301wryer
armer76924442armer
brayer115315312brayer
brier74527402brier
buyer105013092buyer
coyer105222842coyer
crier74724462crier
drier64423962drier
dryers10449272dryers
dyer85522112_dyer
eyer76127282_eyer
feyer115014522feyer
flyer114916252flyer
foyer116416552foyer
freer86021242freer
frier85225842frier
fryers125710972fryers
gayer94519192gayer
grayer106014542grayer
greyer104510092greyer
hayer114620242hayer
layer84626472layer
order65019362order
ormer75218372ormer
oyer75927652_oyer
pacer96131612pacer
pager84728202pager
paler75436932paler
paper95128662paper
parer75839902parer
parker124121372parker
parser84822372parser
partyer12337872partyer
pater74740722pater
paver104225832paver
pawer104422972pawer
payed115925932payed
payee105524722payee
payers114621822payers
payor105413842payor
peer66238352p_eer
per56353092p__er
perter84422282perter
peter74427592peter
pier66035292p_ier
piker115622842piker
piper96523192piper
player115215212player
plier75221282plier
plyers114912982plyers
poker115122882poker
poler74431792poler
porker124917542porker
porter84224412porter
poser75128772poser
power105325952power
prater84825352prater
prayed124815432prayed
prayers124212852prayers
pree67044732pr_ee
preed85128122preed
preen75925052preen
prees75937172prees
prefer113813202prefer
prep86427672pr_ep
prex135722972pr_ex
prey96228482pr_ey
preyed125313202preyed
preyers124412362preyers
preys105717782preys
prez156126312pr_ez
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
prober104516072prober
proem94818272proem
proper104319952proper
proser84223462proser
prover113819722prover
prower114218122prower
pruner83413452pruner
pry85728052pry__
puler74826622puler
purer75127902purer
purger94717232purger
purser85020472purser
pye86432502p_ye_
pyes95528992p_yes
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
ruer46127562_ruer
rye66032542_rye_
ryes75529352_ryes
sayer84926552sayer
shyer114714782shyer
slyer85515122slyer
sprayer12369042sprayer
sprier84119062sprier
toyer84521552toyer
trier54328532trier
truer54916642truer
tuyer85414292tuyer
twyer11558522twyer
tyer75323392_tyer
urger64116472urger
wrier84521752wrier

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.310576422.6
2DLD Change Limit538001212.09325704.7
3Display Results1211210.0333666.7
 (SQL Overall)1786911212.43673354.3
 
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.