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

140 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
upshots123519(None) 
upshoots1344231upshoots
upshot1138451upshot_
gunshots1244372gunshots
phots105418502_p_hots
shots84730852__shots
uproots937142uproots
upsets8409682ups_ets
upshifts1642632upshifts
upshoot1256692upshoot
airshots1145943airshots
ascots85312513_ascots
beshouts1346763beshouts
besots86415453bes_ots
bishops1437033bishops
bowshots1645103bowshots
bullshots1443173bullshots
cashoos12310793cashoos
cushats12288273cushats
dashpots1444193dashpots
despots10319683despots
dipshits1445263dipshits
dropshots1543393dropshots
earshots1146623earshots
ephods1238363ep_hods
ephors11311403ep_hors
escots84211743_escots
eyeshots1453373eyeshots
fusspots1342613fusspots
gumshoes1444123gumshoes
gunshot1156643gunshot_
hipshot15106643hipshot_
hots78349333___hots
hotshots1455513hotshots
mascots113910343mascots
mishits122513083mishits
outshoots1245393outshoots
outshot10312103outshot_
outshouts1245213outshouts
phons105221143_p_hons
phot95534363_p_hot_
photo104417233_p_hoto
photos113316643_p_hotos
phuts104613503_p_huts
picots104616443_picots
pilots84018873_pilots
pinots85920273_pinots
pivots115111903_pivots
plots75025673_p_lots
pots66452363_p__ots
potshots1346283potshots
pshaws14435703_pshaws
psoas75012983_ps_oas
psyops1334343_psyops
pushers123814503pushers
pushes114621663push_es
pushrods1443653pushrods
pushups1433653pushups
reshoes102316033reshoes
reshoots11228413reshoots
reshot93519633reshot_
reshows132510453reshows
respots92912763respots
rimshots1343883rimshots
scots74025913__scots
shits84731173__shits
shoats94117083__shoats
shoes85429663__shoes
shogs95319713__shogs
shoos84226363__shoos
shoots94619363__shoots
shops104222903__shops
shorts95321743__shorts
shot76150263__shot_
shote85526103__shote
shotes95321913__shotes
shott85332193__shott
shotts93614703__shotts
shouts94017723__shouts
shows115324583__shows
shuts85622483__shuts
slots54830533__slots
snapshots1443133snapshots
snots55225123__snots
soots55536213__soots
sots45552453__s_ots
spigots1037793spigots
spots74424113__spots
stots54828553__stots
sunspots1045083sunspots
swots85518433__swots
unhats91110623u_nhats
unknots1144303unknots
unroots738563unroots
unseats73012853unseats
unsets64116163uns_ets
unshifts1444033unshifts
unships1237203unships
unshod1067603unsho_d
unshorn1036943unshorn
unshowy1644173unshowy
unshut939013unshut_
unstops936993unstops
upbeats1195733upbeats
upbows1384683up_bows
upcasts11185643upcasts
updarts1034203updarts
updos8389513up_do_s
upflows1543513upflows
upgrows1334323upgrows
uphold12126903up_hold
upholds13135243up_holds
uphove1436133up_hove
uphroes1236303uphroes
uplifts12424773uplifts
upmost1068193up_most
upprops1044223upprops
uproot8314123uproot_
upsends10265293upsends
upsent83314063upsent_
upset73222593ups_et_
upshift1545113upshift
upsides10319633upsides
upsilons1043173upsilons
upsizes18297163upsizes
upslope1144173upslope
upsoar8105683ups_oar
upsoars985413upsoars
upstarts10165273upstarts
upstate91610493upstate
upstates10189643upstates
upsteps1133743upsteps
upstirs935293upstirs
upstood1044243upstood
upthrows1643303upthrows
uptilts934733uptilts
uptoss836093up_toss
upwafts1541943upwafts
ushers94415533u_shers
washouts1445903washouts

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 Limit1340271406.20321606.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.65526850.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.