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

67 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
maintain107772(None) 
maintains1167101maintains
mainsail1045172mainsail
maintained1343852maintained
maintainer1243512maintainer
mountain1046112mountain
quintain17316222quintain
abstain947253_abstain
amanitin1048463amanit_in
attain6311753_a_ttain
captain112111063ca_ptain
contain9315833_contain
distain8313783_distain
fainting123312163faint_ing
fantail10310233fa_ntail
fountain1144923fountain
gainsaid1043893gainsaid
mailman1137733mailma_n
mainland1145213mainland
mainline1039863main_line
mainmast1245883mainmast
mainsails1144853mainsails
mainstay1344033mainsta_y
mainstays1443393mainstays
maintainers1352833maintainers
maintaining1453593maintaining
maintop1135143maint_op
maintops1244403maintops
manakin131810643ma_nakin
mandarin11411023ma_ndarin
manganin1147543ma_nganin
manikin132110243ma_nikin
mannan85413623ma_nna_n
mannikin14215503mannikin
manta75629913ma_nta__
mantas85725363ma_nta_s
mantic104120903ma_nt_ic
mantid93820383ma_nt_id
mantis83926033ma_nt_is
mantling112012613ma_ntling
mantric11311353ma_ntric
marinating13410273marinating
marination12312813marination
marocain1247063marocain
martian93514683ma_rtian
martin84122523ma_rt_in
matin75132853ma__t_in
mattin84416633ma__ttin
minikin13258983m_inikin
mintage101110123m_intage
minting103020813m_int_ing
minyan1138173m_inya_n
mislain9311243m_islain
mistrain10311943m_istrain
mountains1146363mountains
mountainy1444013mountainy
muntin82915183m_unt_in
painting113614423paint_ing
pintail9311183_pintail
plantain1047903plantain
quintains18306033quintains
quintan16399223quinta_n
quintin163810333quint_in
sainfoin1144153sainfoin
sainting93215733saint_ing
tainting93613583taint_ing
xanthin1747043xa_nthin

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.423422437.4
2DLD Change Limit146162677.48619524.7
3Display Results67670.0302233.3
 (SQL Overall)178691677.93922508.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.