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

294 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
optime107935(None) 
optima10106531optima
optimes1148471optimes
uptime1067671uptime
betime105914832betime
intime81014272intime
onetime937622onetime
ophite11410562ophite
opine77422462op_ine
optic93715182opti_c
optics102810182optics
optimal1145782optimal
optimise1255582optimise
optimize2145502optimize
optimum1343352optimum
opting94514402opting
option83612712option
oxime1498432o_xime
prime96525602_prime
retime85321802retime
septime1138802septime
stime76521802_stime
time66235012__time
uptimes1177552uptimes
active11313743active
adoptive1445503adoptive
airtime948063airtime
anime75423203_anime
anytime1246043anytime
apatite9312963apatite
aplite8316393aplite
attire62412383attire
baptise1139553baptise
baptize2036983baptize
bedtime1236973bedtime
berime105317333berime
betide95115973betide
betimes115114413betimes
betise85616273betise
bigtime1235753bigtime
bootie85421163booti_e
captive1438973captive
centime114513033centime
chime125322593_chime
chowtime1842953chowtime
clime95720893_clime
cootie84223093cooti_e
coppice1537483coppice
costive12312843costive
costume1157853costume
crime94822693_crime
cutie76925933cuti_e
dative10311813dative
daytime1344783daytime
delime9314043delime
dime76237643__dime
downtime1444753downtime
entice81316863entice
entire61617703entire
epimer10109153ep_imer
epitome1157743epitome
footie94718143footi_e
foretime1348213foretime
futile93914953futile
glime85620193_glime
grime85021323_grime
hogtie102711773hogti_e
hoplite12311073hoplite
hostile10312553hostile
hottie92514383hotti_e
intima81910033intima
intimae9109753intimae
intine61021983intine
koppie14277883koppi_e
lime66244933__lime
longtime1144363longtime
mime85736403__mime
mistime11312613mistime
mortice11711493mortice
mortise9713533mortise
motile83818343motile
motive113112143motive
mutine84420373mutine
native9613013native
noontime1095383noontime
notice8313443notice
oatlike113412403oatlike
oblige937653oblige
obtuse8147483obtuse
octane81411633octane
octave11157343octave
office1435693office
ofttimes1343123ofttimes
ogive9379093o_give
oldie6415473oldi_e
oleine6313793oleine
olive84817153o_live
online6315843online
onside7511803onside
ontic74418573onti_c
oolite63319603oolite
oorie53026363oori_e
ootid61416703ooti_d
ootids71110353ootids
opaline9412483opaline
opaque1734213opaque
ope56845243op___e
ophites12310103ophites
opiate8513463opiate
opined95113853op_ined
opines84820703op_ines
oping86322413op_ing
opium92812093op_ium
opiums10307073opiums
oppose1039193oppose
opsin7613473opsi_n
opsins8411713opsins
opt57545543opt___
optative1347653optative
opted84914273opt_ed
optical1149863optical
optimised1444313optimised
optimises1346083optimises
optimism1445213optimism
optimist1256873optimist
optimized2344963optimized
optimizer2244123optimizer
optimizes2245423optimizes
optimums1442563optimums
optioned1146383optioned
optionee1046513optionee
options93810603options
opts68124743opt__s
oreide7311673oreide
oroide7311703oroide
orpine83914483orpine
orrice81410163orrice
oscine8311563oscine
ostia52315583osti_a
ostiole739013ostiole
ostium8310133ostium
ostomy1137833ostomy
otic66624823o_ti_c
otiose639403o_tiose
ourie54027303ouri_e
outage72017533outage
outate62923403outate
outbye1147913outbye
outcome11310573outcome
outfire1049713outfire
outgive11199253outgive
outing74128153outing
outlie62419533outlie
outline72321333outline
outlive102513033outlive
outre53922203out_re
outride82615683outride
outsee63121803outsee
outside82414193outside
outsize162411753outsize
outvie92412803outvie
outwile10310263outwile
overtime131312273overtime
ovine86316643o_vine
oxide131210953o_xide
oxim131114053o_xim_
oximes15107423o_ximes
oxims14107643o_xims
oxlike17307473oxlike
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
podite93315353podite
poetise9314043poetise
poetize18310773poetize
poise75127893_poise
police102918563police
polite83625073polite
pome85636693_p_ome
pommie123710503pommie
pontine92419053pontine
popsie103013053popsi_e
postie84123963posti_e
potage92715903potage
potiche1438043potiche
potion84519573potion
potlike13910123potlike
potline91015233potline
potmen102713093pot_men
potpie103412433potpie
potsie83916033potsie
pottle84416103pottle
poutine93316823poutine
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
ragtime1036163ragtime
ratine65131823ratine
ratite65022423ratite
regime95313943regime
reptile93914083reptile
retie55735303reti_e
retile65929673retile
retimed104714653retimed
retimes95020173retimes
retine66237333retine
retire64927013retire
rime65138883__rime
riptide1036883riptide
routine72615903routine
rutile65217683rutile
satire63218003satire
septimes1238303septimes
showtime1643773showtime
slime74925753_slime
softie93312483softi_e
sometime1246753sometime
sopite84917713sop_ite
sorptive1346473sorptive
sortie63621993sorti_e
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
tame66343663__tame
teatime9310083teatime
tide55237383__tide
tie36557533__ti_e
tike85534483__tike
tile45451443__tile
timed85223613__timed
timer75626043__timer
times75630823__times
tine45855133__tine
tire46143353__tire
tome67543193__tome
tontine72316143tontine
topline92313183topline
topside1037733topside
tortile7313193tortile
ultima836313ultima
ultimo846003ultimo
untame82513603untame
untie54425493unti_e
untimed102713373untimed
updive1234903updive
uppile10178503uppile
uprise82313693uprise
upside9289803upside
upsize17267303upsize
uptake1236963uptake
uptick1436763uptick
uptilt8410803uptilt
uptore8279453uptore
utile54718933_utile
votive12348933votive
wartime1237743wartime
zonetime1944953zonetime

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.390458182.1
2DLD Change Limit1127162944.75023729.7
3Display Results2942940.0933161.3
 (SQL Overall)1786912945.23334147.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.