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

115 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
upscale1113632(None) 
upscaled13144871upscaled
upscales12155991upscales
rescale93215472rescale
scale74629142__scale
subscale1247602subscale
unscaled111410112unscaled
upstage10167442upstage
upstare9158682upstare
upstate91610492upstate
apical10913903apical_
apicals1159923apicals
bascule1136573bascule
boscage1276533boscage
cascable141510623cascable
cascade12118603cascade
cicale10314503_cicale
cupcake1743953cup_cake
discase102912863discase
epical10413393epical_
escape103811663_escape
fiscal1139333fiscal_
fiscals1238003fiscals
inscape1138013inscape
locale83915653_locale
mescal104113483mescal_
mescals112911553mescals
miscall1139643miscall
muscae10410673musca_e
muscle10310973musc_le
musicale1247343musicale
opuscule1242823opuscule
oscule838193_oscule
pale66055013_p__ale
pascal10812373pascal_
pascals11610013pascals
percale11314093percale
pical95524373_pical_
pickle144215653_pickle
psalm949273_ps_alm
psoae74411623_psoa_e
pustule937683pustule
rascal8511123rascal_
rascals959663rascals
resale64025543res_ale
rescaled113311303rescaled
rescales103414573rescales
sale44959703__s_ale
scald84818123__scald
scaled94822443__scaled
scaler84321603__scaler
scales84529313__scales
scall74420373__scall
scalp95217983__scalp
scaly104718723__scaly
scape96921843__scape
scare75334463__scare
shale85332833__shale
spackle15369573spackle
spale74929213__spale
speckle15297553speckle
spicae104313703spica_e
spicate113214193spicate
spicule11269933spicule
stale55637103__stale
subsale9310543subs_ale
subscales1347343subscales
sunscald11113273sunscald
superscale1448003superscale
swale85221593__swale
unbale83616403u_nbale
uncage93014873u_ncage
uncake122813523u_ncake
uncase83817433u_ncase
uncle7317053u_nc_le
unsafe9310693uns_afe
unseal63315473unseal_
unsealed91513623unsealed
unseals73212573unseals
unstable10313763unstable
unstate71916213unstate
upcast102710093up_cast
update93810293up_date
upgaze1833543up_gaze
upgrade11215823upgrade
upheave1544023upheave
uppile10178503up_pile
uprate83916543up_rate
upscaling1444653upscaling
upside9289803ups_ide
upsize17267303ups_ize
upslope1144173upslope
upsoar8105683upsoa_r
upsoared11154353upsoared
upsoars985413upsoars
upstaged12135243upstaged
upstager11164633upstager
upstages11147373upstages
upstair943983upstair
upstand1045343upstand
upstared11156573upstared
upstares10178583upstares
upstart9159753upstart
upstater10156663upstater
upstates10189643upstates
upsurge10134333upsurge
upswell1242723upswell
uptake1236963up_take
uptalk1234653up_talk
ursae55214453urs_a_e
usable84012553u_sable
usage6410213u_s_age
useable9911063u_seable
usual5310183u_sual_
usuals637783u_suals

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271156.25021444.3
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.70226662.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.