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

209 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
septime113880(None) 
septimes1238301septimes
bedtime1236972bedtime
betime105914832be_time
centime114513032centime
optime1079352_optime
peptide122910682peptide
peptize20279482peptize
reptile93914082reptile
retime85321802re_time
sectile9311972sectile
seedtime1144182seedtime
sentimo9449622sentimo
septage1078402septage
septate9511872septate
septic102713192septi_c
septics112810432septics
septum1038002septum_
septums1135742septums
sestine73017922sestine
sextile1438572sextile
stime76521802s__time
teatime9310082teatime
uptime1067672_uptime
airtime948063airtime
anytime1246043anytime
aseptic1137373asepti_c
baptise1139553baptise
baptize2036983baptize
becrime1387053becrime
bedtimes1336593bedtimes
begrime1276553begrime
berime105317333be_rime
beslime1146833beslime
betide95115973be_tide
betimes115114413be_times
betise85616273be_tise
bigtime1235753bigtime
captive1438973captive
centile94217183centile
centimes124012613centimes
centimo11609543centimo
daytime1344783daytime
delime9314043de_lime
dentine83320243dentine
deplume1255063deplume
deprive1338303deprive
depside1138403depside
deputize2045423deputize
destine83719953destine
entice81316863_entice
entire61617703_entire
epimer10109153_ep_imer
epitome1157743_epitome
fertile10311733fertile
festive1339773festive
flextime2042813flextime
gentile83515293gentile
hepatize2248233hepatize
heptane1238363heptane
heptose1237493heptose
intime81014273_intime
leptin82512333lepti_n
leptins92412693leptins
mealtime1245123mealtime
meantime1245983meantime
mistime11312613mistime
onetime937623onetime
optima10106533_optima
optimes1148473_optimes
overtime131312273overtime
pastime114611973pastime
pectize20259913pectize
pepsine11310603pepsine
peptic122113153pepti_c
peptics132610243peptics
peptid112712373pepti_d
peptides132610263peptides
peptids12239323peptids
peptized22237523peptized
peptizer21236473peptizer
peptizes21269853peptizes
peptone11310763peptone
petite84320653pe_tite
prime96525603__prime
psephite1543843psephite
ragtime1036163ragtime
regime95313943re_gime
repine85627813rep_ine
reprice113212833reprice
reprise92715043reprise
reptiles103913063reptiles
restive10315933restive
retie55735303re_ti_e
retile65929673re_tile
retimed104714653re_timed
retimes95020173re_times
retine66237333re_tine
retire64927013re_tire
riptide1036883riptide
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
santimi938793santimi
santims9312603santims
santimu938563santimu
satire63218003s_atire
sceptic1337833scepti_c
sceptics1455663sceptics
sceptre1135053scept_re
seaside839693seaside
seating84130683seating
section92515663section
sedative1238853sedative
sedile73517233se_dile
seedtimes1243943seedtimes
seethe93712483seet_he
seine55732873se__ine
seise54727853se__ise
seize143819503se__ize
selkie102811693selki_e
seme65836653se___me
sememe10129983se_meme
semplice1447013semplice
senile63420213se_nile
sente56432883sent__e
senti56226703senti__
sentiment11410723sentiment
sentimos10407423sentimos
sentinel838703sentinel
sepaline10311343sepaline
sepia75318673sep_i_a
sepias83616103sep_ias
sepic94617053sep_i_c
sepsis83011293sepsi_s
sept65844363sept___
septa75518083sept__a
septages1168263septages
septal84513383sept_al
septet8921133sept_et
septets998953septets
septette1044763septette
septical1259363septical
septs75420603sept__s
septuple1242903septuple
serine65432673se_rine
serotine8313573serotine
service1239093service
servile10310643servile
sesame8311013se_same
sessile739523sessile
sestina72711973sestina
sestines82717243sestines
setae56026223se_t_ae
setline7313923setline
setose65114773se_tose
settee63721023se_ttee
setting83621393setting
settle63915663se_ttle
sextiles1537643sextiles
sheltie10109913shelti_e
showtime1643773showtime
skeptic1545203skepti_c
skeptics1653863skeptics
slime74925753s__lime
smectite1245773smectite
softie93312483softi_e
sometime1246753sometime
sopite84917713sop_ite
sorptive1346473sorptive
sortie63621993sorti_e
specie10412223speci_e
specimen1444423specimen
speise84614253s_peise
spice95528813s_p_ice
spike114922843s_p_ike
spile75230083s_p_ile
spine76534423s_p_ine
spire75828693s_p_ire
spite75430663s_p_ite
splice104915103s_plice
spline86020533s_pline
sprite84421773s_prite
spume95817313s_p_ume
statice92614033statice
stative102612933stative
steatite8310583steatite
stepdame1343623stepdame
steplike1436733steplike
stepwise1344163stepwise
stile54931573s__tile
stimes85920573s__times
stimy105114743s__timy
stipe76523373s__tipe
sublime11310363sublime
subtile91912623subtile
supine84216693sup_ine
supreme1137893supreme
sweetie10157873sweeti_e
teatimes1039443teatimes
tectite9310583tectite
tektite1136883tektite
tentie62521183tenti_e
termtime1244773termtime
textile1437223textile
time66235013___time
uptimes1177553_uptimes
vestige1137433vestige
wartime1237743wartime

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 Limit1340272096.89019452.4
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.37224239.1
 
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.