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

112 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
prayer11481529(None) 
brayer115315311brayer
grayer106014541grayer
payer105125721p_ayer
player115215211player
prater84825351prater
prayed124815431prayed
prayers124212851prayers
preyer114413731preyer
pryer104415311pr_yer
sprayer12369041sprayer
arrayer10136702arrayer
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayed124615782brayed
brayers124511902brayers
brazer174917532brazer
crater85026642crater
craver114618472craver
draper94315692draper
drawer104711362drawer
drayed115911392drayed
dryer95111462dr_yer
eraser64216332eraser
flayer124713562flayer
forayer13368952forayer
framer114817442framer
frater94520592frater
frayed135012162frayed
fryer115913432fr_yer
gayer94519192_gayer
grader84919692grader
grater74625442grater
graver105018592graver
grayed115415642grayed
grazer164815762grazer
greyer104510092greyer
hayer114620242_hayer
irater65218352irater
krater104014312krater
layer84626472_layer
pacer96131612p_acer
pager84728202p_ager
paler75436932p_aler
paper95128662p_aper
parader103914862parader
parer75839902p_arer
parker124121372parker
parser84822372parser
partyer12337872partyer
pater74740722p_ater
paver104225832p_aver
pawer104422972p_awer
payed115925932p_ayed
payee105524722p_ayee
payers114621822p_ayers
payor105413842p_ayor
placer105117742placer
planer84122652planer
plater84427692plater
played124815032played
players124313762players
plyer106214332p_lyer
praiser93413942praiser
prancer113613382prancer
prase76128752prase_
prases84429022prases
prate75135982prate_
prated94924922prated
praters94921652praters
prates84633162prates
prawner1246802prawner
praxes156215182praxes
pray96331532pray__
prays105022432pray_s
preaver121011612preaver
prefer113813202prefer
preyed125313202preyed
preyers124412362preyers
pricer103918292pricer
prier75027762pr_ier
primer105118682primer
prizer174714882prizer
prober104516072prober
proper104319952proper
proser84223462proser
prover113819722prover
prower114218122prower
pruner83413452pruner
pryers115012242pr_yers
racer75233022_racer
raker94529792_raker
raper74932752_raper
rarer54731702_rarer
raser55633412_raser
rater54943282_rater
raver85631492_raver
rawer84623732_rawer
rayed95127502_rayed
razer144824272_razer
sayer84926552_sayer
slayer93916332slayer
sprayed13398902sprayed
sprayers13367052sprayers
spryer11418532spr_yer
stayer94516482stayer
strayer104312502strayer
swayer125210972swayer
tracer84820232tracer
trader75218762trader
wryer11489302wr_yer

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 Filter178691825510.406440125.6
2DLD Change Limit825511122.50033020.4
3Display Results1121120.0303733.3
 (SQL Overall)1786911122.93660862.1
 
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.