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 “meantime” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
meantime124598(None) 
mealtime1245121mealtime
meantimes1345881meantimes
centime114513032ce_ntime
mealtimes1345242mealtimes
meanie83718392mean_i_e
teatime9310082tea_time
anime75423203__an_ime
anytime1246043__anytime
beanie83618593bean_i_e
beanlike14146843beanlike
beastie92412433beasti_e
bedtime1236973be_dtime
betime105914833be__time
centile94217183ce_ntile
centimes124012613ce_ntimes
centimo11609543ce_ntimo
daytime1344783_daytime
dentine83320243de_ntine
downtime1444753downtime
dreamtime1442343dreamtime
emanative1447313emanative
entice81316863_e_ntice
entire61617703_e_ntire
gentile83515293ge_ntile
intime81014273__intime
levantine1264793levantine
manlike133012783m_anlike
mannite9312903m_annite
mantic104120903m_anti_c
mantid93820383m_anti_d
mantids103113623m_antids
mantis83926033m_anti_s
mantises10317923m_antises
mantle84420923m_ant_le
manwise1239183m_anwise
maritime1247383maritime
mealie82519813mea_li_e
meanies93620743mean_ies
meaning103918703mean_ing
meant76537213meant___
meanwhile1752063meanwhile
meatier93214613mea_tier
meatily12311093mea_tily
meatmen1138243mea_t_men
meinie82614523mein_i_e
melanite10512033melan_ite
melanize19410303melan_ize
melastome1344603melastome
mentee84121293me_nt_ee
mention9314373me_ntion
mentum104511713me_ntum_
mercantile1453513mercantile
mistime11312613m_istime
noontime1095383noontime
pantie84326473_panti_e
pantile93918483_pantile
pastime114611973_pastime
peacetime1544473peacetime
playtime1544793playtime
quantile1747323quantile
quantize2645963quantize
ragtime1036163_ragtime
reactive13310473reactive
retime85321803re__time
santimi938793_santimi
santims9312603_santims
santimu938563_santimu
seedtime1144183seedtime
semanteme1342883semanteme
sentimo9449623se_ntimo
septime1138803se_ptime
teatimes1039443tea_times
tentie62521183te_nti_e
termtime1244773termtime
wartime1237743_wartime

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 Filter1786911461620.420425454.8
2DLD Change Limit146162767.20320291.8
3Display Results76760.0332303.0
 (SQL Overall)178691767.65623340.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.