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

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

97 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
maintaining145359(None) 
mainlining1343872main_lining
abstaining1344573_abstaining
attaining1047223_a_ttaining
captaining1546073ca_ptaining
containing13410933_containing
distaining1248903_distaining
fountaining15103643fountaining
intwining1345883__intwining
maintain1077723mainta__in_
maintained1343853maintain_ed
maintainer1243513maintain_er
maintainers1352833maintainers
maintains1167103mainta__ins
mistraining1446503m_istraining
airmailing1343634_airmailing
antiaging1149674_a_ntiaging
antiking13412074_a_nt_iking
attainting1144784_a_ttainting
bargaining1445214ba_rgaining
cantoning12310884ca_nt_oning
curtaining1345534_curtaining
destaining1267944_destaining
detaining112510474__detaining
disdaining1345994_disdaining
distraining1346984_distraining
entailing1039394__entailing
entraining1147644__entraining
entwining1345424__entwining
fainting123312164faint___ing
fantasising1554214fa_ntasising
fantasizing2445374fa_ntasizing
fantasying1743564fa_ntasying
gaingiving16111794gain_giving
gainsaying1542794gainsa_ying
inclining1248404__inclining
ingraining1245624__ingraining
interning10315254__interning
intoning9311124__int_oning
intuiting1089614__intuiting
machining1746934ma__chining
magnetising1553734magnetising
magnetizing2454404magnetizing
mainspring1553794main_spring
maintainable1651724maintainable
manacling1446284ma_n_acling
managing1239094ma_n_a_ging
mandating1339774ma_nda_ting
manganin1147544ma_nga_nin_
manganins1247124ma_nga_nins
manning103616384ma_n___ning
mantling112012614ma_nt__ling
marathoning1752824marathoning
margining1337604ma__rgining
marinading1445614marin_a_ding
marinating13410264marin_a_ting
mentioning1345794m_entioning
minimising1544934m_inimising
minimizing2445554m_inimizing
minting103020814m_int___ing
misaiming1437874m_i_saiming
misatoning1346444m_isatoning
miscoining1597764m_iscoining
misjoining2085294m_isjoining
mispainting1645294m_ispainting
misraising1348124m_israising
mistaking1699694m_ista_king
misthinking2143424m_isthinking
mistiming1438914m_ist_iming
mistuning1237674m_ist_uning
moistening1346234moist_ening
montaging1346544m_onta_ging
moonshining1752034moonshining
munitioning1453034munitioning
mutining11310494m__ut_ining
obtaining1236774__obtaining
painstaking1852854painsta_king
painting113614424paint___ing
patining11312304pa__t_ining
pertaining1347994_pertaining
rainmaking1743974rainma_king
rainwashing1852264rainwashing
reattaining1244594reattaining
reobtaining1443534reobtaining
retaining102114734__retaining
sainting93215734saint___ing
sanitating1149644sanita_ting
sanitising11116574sanit_ising
sanitizing20107954sanit_izing
staining9413374___staining
suntanning1143984_suntanning
sustaining1145884_sustaining
tainting93613584taint___ing
tantalising1246204ta_ntalising
tantalizing2158074ta_ntalizing
untwining1346304__untwining
wantoning1337084wa_nt_oning

Search took 10 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 Filter1786911488190.410435831.7
2DLD Change Limit148819979.14016282.2
3Display Results97970.0462108.7
 (SQL Overall)178691979.59618621.4
 
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.