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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
reply10401585(None) 
redly94217201redly
refly113914561refly
rely75428951re_ly
repay104818451repay
replay113412921replay
amply125012912amply
apply125111392apply
belly104625492belly
crepey135110932crepey
crepy124812702crep_y
deeply1257012deeply
delly96023872delly
deploy1237582deploy
eely77725212_eely
felly114922802felly
ferly115517352ferly
feyly14429512feyly
freely12310962freely
greyly13316542greyly
haply135915062haply
hiply134113612hiply
imply124911842imply
jelly154218252jelly
kelly124617022kelly
kelpy145110682kelpy
mealy104422182mealy
nelly84618812nelly
newly114610202newly
pepla9312862pepla
peppy114310362peppy
ply86323552__ply
prepay13310312prepay
preppy1235522preppy
rally84725902rally
raptly11338912raptly
rawly115115832rawly
ready94821502ready
real45750292real_
really93315612really
realm75621622realm
reals55038652reals
realty92713692realty
reapply1434322reapply
rebuy104714682rebuy
redry94314362redry
reedy910020292reedy
reefy114217702reefy
reeky125416262reeky
reel45240532reel_
reels55333262reels
refry114412462refry
reify114814972reify
rekey124014732rekey
relay84424672relay
rep55847802rep__
repays113813972repays
repeg84015052repeg
repel74921402repel
repels84318762repels
repin75324702repin
replan83215822replan
replays12399762replays
repled93319782repled
replevy1533472replevy
replot83818592replot
replow114210342replow
repo66027542rep_o
repoll8410792repoll
repos74725792repos
repot75132622repot
repp85418742rep_p
repps95114342repps
repro75315912repro
reps65937952rep_s
resay85320542resay
retry84718082retry
ripely112511152ripely
ripply13348002ripply
roily86121112roily
ropey106021872ropey
ropily113312442ropily
ropy96323412rop_y
ruly76323142r_uly
rumply13348572rumply
seely84522632seely
sepoy10314302sepoy
telly84920822telly
tepoy10312162tepoy
trebly1138972trebly
triply114211022triply
vealy115817772vealy
welly114620012welly
wetly114511712wetly

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 Limit53800941.45337026.8
3Display Results94940.0165875.0
 (SQL Overall)178691941.779100444.6
 
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.