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

212 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
teatime931008(None) 
teatimes1039441teatimes
bedtime1236972bedtime
betime105914832be_time
centime114513032centime
mealtime1245122mealtime
meantime1245982meantime
retime85321802re_time
septime1138802septime
steatite8310582steatite
tealike111111082tealike
tectite9310582tectite
tektite1136882tektite
tentie62521182tenti_e
termtime1244772termtime
textile1437222textile
treatise8311102treatise
aftertime1445473aftertime
agatize1739833agatize
airtime948063airtime
amative12311733amative
anime75423203__anime
anytime1246043anytime
apatite9312963apatite
beanie83618593beani_e
beastie92412433beasti_e
beatify1536593beatify
beating104326873beating
becrime1387053becrime
bedtimes1336593bedtimes
begrime1276553begrime
berime105317333be_rime
beslime1146833beslime
betaine9413783betaine
betide95115973be_tide
betimes115114413be_times
betise85616273be_tise
bigtime1235753bigtime
centile94217183centile
centimes124012613centimes
centimo11609543centimo
creatine103417413creatine
creative132812803creative
dative10311813_dative
daytime1344783daytime
dearie73319813deari_e
delime9314043de_lime
dentine83320243dentine
destine83719953destine
dreamtime1442343dreamtime
eating75134403_eating
elative10312453elative
entice81316863_entice
entire61617703_entire
etamine91313073etamine
etatism9610293etatism
etatisms1038293etatisms
etatist7415033etatist
feature1039853feature
fertile10311733fertile
festive1339773festive
flextime2042813flextime
gelatine93213313gelatine
gentile83515293gentile
gratine84719193gratine
heating114024323heating
heaume1137543hea_ume
hematine131614673hematine
hematite131612153hematite
hepatize2248233hepatize
ideative1238573ideative
intime81014273_intime
isatine7311763isatine
iterative12410713iterative
legatine91311403legatine
mealie82519813meali_e
mealtimes1345243mealtimes
meanie83718393meani_e
meantimes1345883meantimes
meatier93214613meatier
meatily12311093meatily
meatmen1138243meat_men
mistime11312613mistime
native9613013_native
negative1239083negative
onetime937623onetime
optime1079353_optime
overtime131312273overtime
pastime114611973pastime
patine85328123_patine
peacetime1544473peacetime
pealike131211273pealike
peatier94017233peatier
pectize20259913pectize
peptide122910683peptide
peptize20279483peptize
petite84320653pe_tite
playtime1544793playtime
ragtime1036163ragtime
ratine65131823_ratine
ratite65022423_ratite
reactive13310473reactive
realise73021813realise
realize162717083realize
regime95313943re_gime
relative11313143relative
reptile93914083reptile
restive10315933restive
retie55735303re_ti_e
retile65929673re_tile
retimed104714653re_timed
retimes95020173re_times
retine66237333re_tine
retire64927013re_tire
satire63218003_satire
seaside839693seaside
seating84130683seating
sectile9311973sectile
sedative1238853sedative
seedtime1144183seedtime
sentimo9449623sentimo
septimes1238303septimes
sestine73017923sestine
sextile1438573sextile
statice92614033statice
stative102612933stative
stearine8311903stearine
steatites939843steatites
stime76521803__stime
tactile9310613tactile
taeniae739083taeniae
tame66343663t_a__me
tammie104212693t_ammie
tatami839193t_atami
tate44748603t_at__e
tattie64817513t_attie
tattle64115653t_attle
tawie84819813t_awi_e
taxeme1536253t_axeme
taximen1644923t_aximen
taxite13511303t_axite
teacake1335453teacake
team66238653tea__m_
teamed95418593tea__med
teaming103917593teaming
teams75726513tea__ms
tearier73815613tearier
tearily10311153tearily
tearing84021493tearing
tease55428713tea__se
teasing83918513teasing
teat45963633teat___
teated74924023teat_ed
teats55636813teat__s
teaware1048143teaware
teazle15329553tea_zle
techie11511723techi_e
tectites1039993tectites
tectum10328603tectum_
tectums11306423tectums
teethe94511313teet_he
tekkie934203tekki_e
tektites1236613tektites
telome8311923te_lome
teniae64517353te_niae
tensile72612733tensile
tensive10269913tensive
tentage81010643tentage
tentative1247813tentative
tentier73815923tentier
tenting84621153tenting
tentlike1236903tentlike
teratism10312173teratism
teratisms11410073teratisms
teratoma1047143teratoma
tergite8311003tergite
termite9313893termite
termtimes1354803termtimes
terrine72517573terrine
tertial7313863tertial
tertian7511193tertian
testae64216253test_ae
testate73916233testate
testee64323303test_ee
testicle1037443testicle
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713testi_s
tetanise8610203tetanise
tetanize17109953tetanize
textiles1536833textiles
texture1497083texture
theatre10358493theat_re
time66235013___time
tittie63213153titti_e
tontine72316143tontine
tortile7313193tortile
tractile10311073tractile
tractive13310043tractive
treaties8316983treaties
treating92519613treating
treatises9310373treatises
tsatske1141833tsatske
twasome1244623twasome
twattle1064273twattle
uptime1067673_uptime
vestige1137433vestige
wartime1237743wartime
zeatin15412823zeati_n
zeatins16311733zeatins

Search took 7 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.420425454.8
2DLD Change Limit1340272126.17321711.8
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.66926794.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.