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

266 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
uptime106767(None) 
optime1079351optime
uptimes1177551uptimes
betime105914832betime
intime81014272intime
optima10106532optima
optimes1148472optimes
prime96525602_prime
retime85321802retime
septime1138802septime
stime76521802_stime
time66235012__time
ultima836312ultima
ultimo846002ultimo
untame82513602untame
untie54425492unti_e
untimed102713372untimed
updive1234902updive
uppile10178502uppile
uprise82313692uprise
upside9289802upside
upsize17267302upsize
uptake1236962uptake
uptick1436762uptick
uptilt8410802uptilt
uptore8279452uptore
utile54718932u_tile
active11313743active
airtime948063airtime
anime75423203_anime
anytime1246043anytime
apatite9312963apatite
aplite8316393aplite
attire62412383attire
auntie64317703aunti_e
baptise1139553baptise
baptize2036983baptize
bedtime1236973bedtime
berime105317333berime
betide95115973betide
betimes115114413betimes
betise85616273betise
bigtime1235753bigtime
buppie12288733buppi_e
captive1438973captive
centime114513033centime
chime125322593_chime
clime95720893_clime
crime94822693_crime
cuplike1537213cuplike
cuprite1159683cuprite
cutie76925933cuti_e
dative10311813dative
daytime1344783daytime
delime9314043delime
dime76237643__dime
ductile1048483ductile
entice81316863entice
entire61617703entire
epimer10109153ep_imer
epitome1157743epitome
eruptive1345793eruptive
furtive1337173furtive
futile93914953futile
glime85620193_glime
grime85021323_grime
intima81910033intima
intimae9109753intimae
intine61021983intine
justice1637423justice
lime66244933__lime
lupine84013533lup_ine
mime85736403__mime
mistime11312613mistime
motile83818343motile
motive113112143motive
mutine84420373mutine
native9613013native
notice8313443notice
nuptial946633nuptial
onetime937623onetime
ophite11410563ophite
opine77422463op_ine
optic93715183opti_c
optics102810183optics
optimal1145783optimal
optimise1255583optimise
optimize2145503optimize
optimum1343353optimum
opting94514403opting
option83612713option
oxime1498433_oxime
paise75028333_paise
pastime114611973pastime
patine85328123patine
peise75825773_peise
peptide122910683peptide
peptize20279483peptize
petite84320653petite
pice84641093_p_ice
pie55457403_p_i_e
pike106335213_p_ike
pile65649693_p_ile
pima85428653_p_ima
pimp106024903_p_imp
pine67755713_p_ine
pipe86434433_p_ipe
pitmen102510793_pitmen
plie65127393_pli_e
plume94819463_plume
poise75127893_poise
pome85636693_p_ome
price93725413_price
pride84724733_pride
prim85132203_prim_
prima95019343_prima
primed115118913_primed
primer105118683_primer
primes104225263_primes
primi95017403_primi
primo95017913_primo
primp115615923_primp
prims95425933_prims
prise74632613_prise
prize164718943_prize
pumice1238223pumice
purine85321893purine
putamen1135923putamen
puttee85919723puttee
puttie84116303puttie
ragtime1036163ragtime
ratine65131823ratine
ratite65022423ratite
regime95313943regime
reptile93914083reptile
retie55735303reti_e
retile65929673retile
retimed104714653retimed
retimes95020173retimes
retine66237333retine
retire64927013retire
rime65138883__rime
riptide1036883riptide
rupture966163rupture
rutile65217683rutile
satire63218003satire
septimes1238303septimes
slime74925753_slime
speise84614253speise
spice95528813sp_ice
spike114922843sp_ike
spile75230083sp_ile
spine76534423sp_ine
spire75828693sp_ire
spite75430663sp_ite
splice104915103splice
spline86020533spline
sprite84421773sprite
spume95817313sp_ume
stile54931573_stile
stimes85920573_stimes
stimy105114743_stimy
stipe76523373_stipe
sublime11310363sublime
subtile91912623subtile
supine84216693sup_ine
supreme1137893supreme
tame66343663__tame
teatime9310083teatime
tide55237383__tide
tie36557533__ti_e
tike85534483__tike
tile45451443__tile
timed85223613__timed
timer75626043__timer
times75630823__times
tine45855133__tine
tire46143353__tire
tome67543193__tome
ugsome934783ugsome
ultimas936363ultimas
ultimate1049203ultimate
umpire1047893umpire
unaimed102812493unaimed
unciae83215313unciae
undine7817263undine
unite54828383u_nite
unitive10310563unitive
unitize16310033unitize
unlike102614063unlike
unlive92712333unlive
unpile81914323unpile
unprimed1337203unprimed
unrimed102211633unrimed
unripe82012093unripe
untamed102913223untamed
untidy1059153untidy
untied73720813untied
unties64326923unties
until53517743unti_l
untimely1346903untimely
untired82316383untired
untrim8310683untrim_
untrims938613untrims
untrue6310773untrue
untune62511603untune
untwine1038623untwine
unwise9510803unwise
upbind11246313upbind
upbore10247883upbore
upbye1244793up_bye
upclimb1542133upclimb
update93810293update
updived1434093updived
updives1334713updives
updove1234483updove
upgaze1833543upgaze
upgird10103933upgird
upgirt9117263upgirt
uphill11106173uphill
uphove1436133uphove
uphroe1136083uphroe
uplift114610653uplift
uplink12388713uplink
uplit76020803upli_t
uppiled12216593uppiled
uppiles11208263uppiles
upping114013703upping
uppish1336633uppish
uppity1335103uppity
upraise9158603upraise
uprate83916543uprate
uprisen9227353uprisen
upriser9218763upriser
uprises92012733uprises
upriver12196933upriver
uprose82311483uprose
upsides10319633upsides
upsized19246253upsized
upsizes18297163upsizes
upstage10167443upstage
upstare9158683upstare
upstate91610493upstate
upstir835383upsti_r
upstirs935293upstirs
uptakes1336593uptakes
uptalk1234653uptalk
uptear896783uptear
uptempo1342413uptempo
upthrew1542663upthrew
upticks1535153upticks
uptight13176033uptight
uptilted1174683uptilted
uptilts934733uptilts
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upturn8286243upturn
upwind12255823upwind
ureide7310363ureide
urine55026603u_rine
ursine64114123ursine
ute35335883u_t__e
votive12348933votive
wartime1237743wartime
yuppie13297133yuppi_e

Search took 6 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.376475242.0
2DLD Change Limit1127162665.45320670.5
3Display Results2662660.0763500.0
 (SQL Overall)1786912665.90530261.0
 
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.