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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
upscaled1314487(None) 
unscaled111410111unscaled
upscale11136321upscale_
upscales12155991upscales
rescaled113311302rescaled
scaled94822442__scaled
unsealed91513622unsealed
upsoared11154352upsoared
upstaged12135242upstaged
upstared11156572upstared
appealed1335603appealed
ascared10399523_ascared
cascaded14135703cascaded
discalced1545653discalced
discased122510853discased
escaped12388853_escaped
miscalled1447443miscalled
muscled1237783musc_led
paled85538723_p__aled
pealed95322813_p_ealed
pedaled113711893_pedaled
petaled103614153_petaled
pickled164011883_pickled
psalmed1234503_ps_almed
pshawed16103033_pshawed
pustuled1134953pustuled
rescale93215473rescale_
rescales103414573rescales
resealed92713973resealed
scald84818123__scal_d
scalded11409763__scalded
scale74629143__scale_
scaler84321603__scaler
scales84529313__scales
scalped124411993__scalped
scaped115519553__scaped
scared95227293__scared
sealed74328363__sealed
shaled105023953__shaled
spackled17297803spackled
speckled17255833speckled
spicated13309903spicated
spiraled1137733spiraled
staled74728103__staled
subscale1247603subscale_
subscales1347343subscales
sunscald11113273sunscal_d
unbaled103315963u_nbaled
uncaged113314123u_ncaged
uncaked143514353u_ncaked
uncalled11810923u_ncalled
uncased104216953u_ncased
unhealed121511073unhealed
unsalted9510923uns_alted
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscanned1245133unscanned
unscarred1235673unscarred
unscathed1535313unscathed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unslaked1338463unslaked
unsnarled1035743unsnarled
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unstalked1435523unstalked
unstated91615813unstated
unstayed12168393unstayed
unswayed15155713unswayed
upboiled13194853upboiled
upcoiled13215183upcoiled
upcurled1393783upcurled
updated11369423up_dated
upgazed2033423up_gazed
upgraded13215683upgraded
upheaped1633643upheaped
upheaved1733763upheaved
upleaped1334333upleaped
uploaded1234533uploaded
uppiled12216593up_piled
uprated103213323up_rated
upreared1137073upreared
upscaling1444653upscaling
upsized19246253ups_ized
upstage10167443upstage_
upstager11164633upstager
upstages11147373upstages
upstand1045343upsta_nd
upstare9158683upstare_
upstares10178583upstares
upstarted1244213upstarted
upstate91610493upstate_
upstater10156663upstater
upstates10189643upstates
upsurged12124043upsurged
upswelled1542903upswelled
uptalked1533053up_talked
upwelled1434663upwelled

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621057.00020880.3
3Display Results1051050.0333181.8
 (SQL Overall)1786911057.45323975.7
 
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.