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

106 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
upper9371426(None) 
cupper124313861cupper
supper104115431supper
upped103715161upped
uppers102912291uppers
aper66336232_aper
appear10379342appear
appel94615892appel
apter76120202apter
asper75520432asper
bopper123813832bopper
bumper123714342bumper
caper94831622caper
capper124421982capper
coper95336092coper
copper124321892copper
crupper13338562crupper
cupped134413982cupped
cuppers133712212cuppers
cuppier1368322cuppier
dapper114016632dapper
dipper114017792dipper
doper86128392doper
dumper114615212dumper
duper85519002duper
dupped124411642dupped
gaper86125122gaper
gipper114215302gipper
gulper93410212gulper
gypper14347292gypper
hepper133412662hepper
hipper133818022hipper
hoper105829142hoper
hopper134218482hopper
humper134115882humper
hyper135213902hyper
japer146218882japer
jumper173612372jumper
kipper143414212kipper
lapper104319952lapper
leper74820742leper
lipper104219632lipper
loper75129232loper
lopper103717202lopper
lumper103816652lumper
mapper124516092mapper
moper94925922moper
mopper126215002mopper
mumper123513522mumper
napper103718282napper
nipper103715712nipper
paper95128662paper
peer66238352_peer
pepper93512942pepper
per56353092__per
pier66035292_pier
piper96523192piper
popper93615962popper
puler74826622puler
pulper103513272pulper
pumper124415552pumper
pupped105013272pupped
puppet93514592puppet
purer75127902purer
quipper2095822quipper
raper74932752raper
rapper104621572rapper
riper74328402riper
ripper103518652ripper
roper75431912roper
sapper103822352sapper
scupper1367422scupper
sipper103920992sipper
speer74623902speer
spier75728032spier
super74924482super
supped114415702supped
suppers113314702suppers
suppler1148432suppler
taper74829772taper
tapper104419612tapper
tipper103918412tipper
toper75231022toper
topper103817602topper
tupped114013232tupped
udder76314282udder
ulcer7310752ulcer
umber94617592umber
umped104717272umped
under64624212under
unpeg8309362unpeg
unpen72913572unpen
upbear1096492upbear
uprear8168792uprear
upset73222592upset
uptear896782uptear
urger64116472urger
urped84615282urped
user45023002u_ser
usher84517762usher
utter54218762utter
viper105017302viper
wiper105421292wiper
yapper133714512yapper
zapper193414022zapper
zipper193813122zipper

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.330541487.9
2DLD Change Limit538001061.61033416.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911061.97090706.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.