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

173 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
upstare915868(None) 
upstage10167441upstage
upstared11156571upstared
upstares10178581upstares
upstart9159751upstart
upstate91610491upstate
outstare81410692outstare
stare54440262__stare
unstate71916212unstate
upscale11136322upscale
upsoar8105682upsoar_
upsoared11154352upsoared
upsoars985412upsoars
upstaged12135242upstaged
upstager11164632upstager
upstages11147372upstages
upstair943982upstair
upstairs1043642upstairs
upstand1045342upstand
upstarted1244212upstarted
upstarts10165272upstarts
upstater10156662upstater
upstates10189642upstates
upstir835382upstir_
upstirs935292upstirs
uptake1236962up_take
uptore8279452up_tore
apostate1049853apostate
austere7312993austere
bastard103012423bastard
bistate9313823bistate
bistre83815023bist_re
bustard10389723bustard
centare93113703centare
costae85319683costa_e
costar85518613costar_
costard104113353costard
costars94218013costars
costate94019273costate
custard10389973custard
dastard9279703dastard
ensnare767123ensnare
estate64719763_estate
gestate83614073gestate
gesture839243gesture
hastate10313913hastate
hectare1238473hectare
hektare1435513hektare
hostage113111233hostage
insnare748243insnare
instar6310013instar_
instars7411133instars
instate71616483instate
lustre64011683lust_re
mistake131312623mistake
mustard10359533mustard
onstage838363onstage
outstared10188423outstared
outstares91610183outstares
outstart81611283outstart
outstate81411993outstate
outsware11168843outsware
pare66760843_p__are
pasture9311463pasture
petard95013803_petard
postage103214853postage
posture9313253posture
potage92715903_potage
psoae74411623_psoa_e
pustule937683pustule
restage83316193restage
restart7320033restart
restate73824883restate
restore75822983restore
rupture966163rup_ture
scare75334463__scare
share86437083__share
snare54429983__snare
spare75135563__spare
stade64825303__stade
stage65330193__stage
stake95927533__stake
stale55637103__stale
stane55933003__stane
star48037763__star_
stared75429873__stared
starer64027363__starer
stares66038753__stares
stark95425623__stark
stars55836573__stars
start55642313__start
starve94613743__starve
state56237333__state
stave85324993__stave
stere55328543__stere
store56333813__store
substage11117183substage
substate101711093substate
sware85828213__sware
tare45957623___tare
tartare73012683tartare
testae64216253testa_e
testate73916233testate
ulster63712103ulster_
ulsters72711983ulsters
unaware1038033unaware
unitage838993unitage
unitard838003unitard
unitary1038613unitary
unsafe9310693uns_afe
unseared91113943unseared
unshared121510703unshared
unsharp1235543unsharp
unsmart939603unsmart
unsnarl7107153unsnarl
unstable10313763unstable
unstack1337373unstack
unstarred1036363unstarred
unstated91615813unstated
unstates81314993unstates
unstayed12168393unstayed
unstrap946783unstrap
unsure62815413uns_ure
unswore1039053unswore
untame82513603u_ntame
upbear1096493upbear_
upbearer1243583upbearer
upbears1195423upbears
upbore10247883up_bore
updart9310743up_dart
update93810293up_date
updater10347253updater
upgaze1833543up_gaze
upgrade11215823upgrade
upheave1544023upheave
uphoard1344573uphoard
uprate83916543up_rate
uprear8168793uprear_
upreared1137073upreared
uprears9107493uprears
uproar8106933uproar_
uproars986453uproars
upscaled13144873upscaled
upscales12155993upscales
upsetter1034643upsetter
upside9289803ups_ide
upsize17267303ups_ize
upslope1144173upslope
upstagers12173333upstagers
upstands1144093upstands
upstaring1235963upstaring
upstaters11174803upstaters
upstep1035503upst_ep
upsteps1133743upsteps
upstirred1241823upstirred
upstood1044243upstood
upstream1243553upst_ream
upstroke1443993upstroke
upsurge10134333upsurge
uptakes1336593up_takes
uptalk1234653up_talk
uptear896783uptear_
uptears9106453uptears
upthrew1542663up_threw
uptime1067673up_time
uptorn8268093up_torn
upturn8286243up_turn
upward12147163up_ward
urare56322553u__rare
ursae55214453urs_a_e
usage6410213u_s_age
vesture10310373vesture
wastage11109253wastage

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.406440125.6
2DLD Change Limit1340271736.73619897.1
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.20224811.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.