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

154 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
upshot113845(None) 
upshoot1256691upshoot
upshots1235191upshots
gunshot1156642gunshot
hipshot15106642hipshot
outshot10312102outshot
phot95534352_p_hot
reshot93519632reshot
shot76150242__shot
unshod1067602unshod
unshut939012unshut
uproot8314122uproot
upsent83314062upsent
upset73222592ups_et
upshift1545112upshift
upshoots1344232upshoots
airshot1059493airshot
ascot76522513_ascot
beshout12311833beshout
besot76429713bes_ot
bishop1336943bishop
bowshot1578253bowshot
buckshot1954963buckshot
bullshot1345053bullshot
cashoo11312253cashoo
cushat113513693cushat
dashpot1346123dashpot
despot93413293despot
dipshit1347993dipshit
dropshot1445073dropshot
earshot10410823earshot
ephod1139123ep_hod
ephor10310013ep_hor
escot75320083_escot
eyeshot1386543eyeshot
fusspot1244073fusspot
gumshoe1343663gumshoe
gunshots1244373gunshots
hot67776053___hot
hotshot1358343hotshot
mascot104016073mascot
mishit112618193mishit
outshoot1149163outshoot
outshout1149483outshout
phat95837863_p_hat
phon95925383_p_hon
photo104417223_p_hoto
phots105418493_p_hots
pht86030523_p_h_t
phut96925973_p_hut
picot95031013_picot
pilot77435063_pilot
pinot78737293_pinot
pivot106523873_pivot
plot66141233_p_lot
pot58078433_p__ot
potshot1249733potshot
pshaw13447513_pshaw
psst66118403_ps_st
pst57932513_ps__t
push95526623push__
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pushrod1343703pushrod
pushup1335273pushup
pushy134614353push_y
reshod103012233reshod
reshoe92816483reshoe
reshoot102513893reshoot
reshow123111433reshow
respot83117633respot
rimshot1246213rimshot
scot66242603__scot
shat76456593__shat
shit76745933__shit
shoat85633943__shoat
shod86225053__shod
shoe75933433__shoe
shog86025133__shog
shoo75929883__shoo
shoot84235893__shoot
shop95629833__shop
short85040523__short
shote85526083__shote
shots84730833__shots
shott85332173__shott
shout85433163__shout
show106229183__show
shut76137583__shut
slot46049823__slot
snapshot1344393snapshot
snot44745443__snot
soot45761053__soot
sot310384293__s_ot
spigot9312603spigot
spot65540683__spot
stot46347323__stot
sunspot947163sunspot
superhot13410223superhot
swot75134653__swot
ungot61718063u_ngot
unhat81119263u_nhat
unknot1037413unknot
unroot6315553unroot
unseat64221023unseat
unsent63820963unsent
unset54532433uns_et
unshed10313773unshed
unshift1387413unshift
unship1148033unship
unshorn1036943unshorn
unshowy1644173unshowy
unstop837473unstop
upbeat10911513upbeat
upbow1245613up_bow
upcast102710093upcast
updart9310743updart
updo76712883up_do_
updos8389513up_dos
upflow1433523upflow
upfront1246973upfront
upgirt9117263upgirt
upgrow1234273upgrow
uphold12126903up_hold
uphove1436133up_hove
uphroe1136083uphroe
uplift114610653uplift
uplit76020803up_lit
upmost1068193upmost
upo58925863up__o_
upon65817583up__on
upprop944093upprop
uproots937143uproots
ups55629053ups___
upsend9356883upsend
upsets8409683upsets
upshifts1642633upshifts
upside9289803upside
upsilon943583upsilon
upsize17267303upsize
upslope1144173upslope
upsoar8105683upsoar
upstart9159753upstart
upstate91610493upstate
upstep1035503upstep
upstir835383upstir
upstood1044243upstood
upswept1443473upswept
upthrow1543193upthrow
uptilt8410803uptilt
upwaft1444943upwaft
usher84517763u_sher
washout13410133washout

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161547.01616065.6
3Display Results1541540.0463347.8
 (SQL Overall)1786911547.18524870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.