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

179 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
upstirs93529(None) 
upstairs1043641upstairs
upstir835381upstir_
bestirs9311132bestirs
stirs55921622__stirs
ulsters72711982ulsters
upsoars985412upsoars
upstair943982upstair_
upstare9158682upstare
upstares10178582upstares
upstart9159752upstart
upstarts10165272upstarts
upsteps1133742upsteps
apostils1046773apostils
apsis75718293aps_i_s
asters65631603_asters
astir55517093_astir_
basters94930303basters
bestir8311163bestir_
bisters93922613bisters
bursters1038983bursters
busters94724133busters
bustics11810883bustics
bustiers103810053bustiers
casters94729903casters
castors94919443castors
costars94218013costars
costers94128333costers
distils83015803distils
dumpsters1453743dumpsters
dusters84918363dusters
easters75125683easters
esters64627733_esters
festers104121393festers
fosters104220103fosters
fustics1279593fustics
gasters85624293gasters
gypsters1434023gypsters
hipsters13268793hipsters
instars7411133instars
instils7811453instils
jesters144118193jesters
justers143815733justers
lasters75627693lasters
listers74026533listers
lusters73921443lusters
maftirs1236043maftirs
masters94628923masters
mastics112614783mastics
misters93927513misters
munsters104010553munsters
musters94522513musters
mystics14279103mystics
nasties73520493nasties
nesters74422793nesters
nestors73614973nestors
opsins8411713ops_ins
optics102810183op_tics
ousters74122793ousters
oysters103411693oysters
pairs75325833_p_airs
pasters94531733pasters
pasties94529813pasties
pastils94416173pastils
pastis84924323pasti_s
pastors94119003pastors
paters84935833_paters
patins87528783_patins
patios85221783_patios
pesters93827093pesters
peters86624593_peters
pistils93314303pistils
pitiers93812653_pitiers
pities83828083_pities
posters93928013posters
posties93128813posties
postins93721203postins
psis68120343_ps_i_s
punsters103310583punsters
punters93617043punters
punties94520783punties
pushers123814503pushers
pussies93615693pussies
putters94219193putters
puttiers10288013puttiers
putties94420023putties
questers17168763questers
questors17147013questors
quipsters2043593quipsters
rasters74629023rasters
resters74130403resters
rosters73727543rosters
rustics9810733rustics
santirs7312963santirs
sirs44338333__s_irs
sisters73721593sisters
spastics1237503spastics
speirs85013233sp_eirs
stairs65416333__stairs
stars55836573__stars
sties55132983__sties
stir45723253__stir_
stirk95717413__stirk
stirks104914243__stirks
stirp76815503__stirp
stirps85011823__stirps
tapsters10318803tapsters
tasters74225643tasters
testers74124543testers
testis64916713testi_s
tipsters10278513tipsters
ulster63712103ulster_
unhairs1036373unhairs
uniters73814173uniters
unities72520153unities
unships1237203unships
unsteps936213unsteps
unstick1338123unstick
unsticks1436233unsticks
unstops936993unstops
unties64326923u_nties
upbears1195423upbears
upboils1184703upboils
upcoils1184933upcoils
updaters11255183updaters
updries10209083updries
upgird10103933up_gird
upgirds11103073up_girds
upgirt9117263up_girt
uppers102912293up_pers
uprears9107493uprears
uproars986453uproars
upsends10265293upsends
upsets8409683ups_ets
upsetters1143653upsetters
upshift1545113upshift
upshifts1642633upshifts
upshots1235193upshots
upside9289803ups_ide
upsides10319633upsides
upsize17267303ups_ize
upsizes18297163upsizes
upsoar8105683upsoar_
upstage10167443upstage
upstagers12173333upstagers
upstages11147373upstages
upstand1045343upstand
upstands1144093upstands
upstared11156573upstared
upstate91610493upstate
upstaters11174803upstaters
upstates10189643upstates
upstep1035503upst_ep
upstirred1241823upstirred
upstood1044243upstood
upswing1335593upswing
upswings1433003upswings
uptears9106453uptears
uptick1436763up_tick
upticks1535153up_ticks
uptilt8410803up_tilt
uptilts934733up_tilts
uptime1067673up_time
uptimes1177553up_times
uptore8279453up_tore
uptorn8268093up_torn
uptoss836093up_toss
upturn8286243up_turn
upturns9264973up_turns
ureters7311823ureters
ursids737823urs_ids
users55817573u_s_ers
ushers94415533u_shers
utters63817123u_tters
wasters104026593wasters
westers105221963westers
xysters17307163xysters
zesters163517293zesters
zosters163015413zosters

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271796.83019623.3
3Display Results1791790.0602983.3
 (SQL Overall)1786911797.28024545.5
 
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.