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

68 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
bandmates144792(None) 
bandmate1347971bandmate_
animates101316422_animates
baldpates1445232baldpates
bandages12310632band_ages
bandmaster15124412bandmaster
bandmasters1684182bandmasters
bedmates1349182b_edmates
bunkmates1743672bunkmates
mandates11314092mand_ates
abnegates1244943abnegates
agemates111110023_agemates
andantes9310853_andantes
animate91617213_animate_
animated111612373_animated
animater101512393_animater
animaters11129973_animaters
annates72415423_an_nates
backdates1848153backdates
baldpate1345483baldpate_
baldpated1543823baldpated
bandage11311023band_age_
bandaged1337313band_aged
bandager1237703band_ager
bandagers1335883band_agers
bandanas11178573band_anas
bandas95120543band_a__s
bandboxes2143793bandboxes
bandeaus1146503bandea_us
bandies104124863band__ies
banditos11347633band_itos
bandits103814793band_it_s
bandores11311603band_ores
bandsaws1444623bandsa_ws
banjaxes2443393ban_jaxes
banknotes1544313banknotes
basmatis1247343ba_smatis
bathmats1545933bathmat_s
bedmate1239433b_edmate_
benzoates2044093benzoates
bondages1237893bond_ages
bondmaids1542663bondmaids
bromates12413143b_romates
bunkmate1643963bunkmate_
candidates1446303candidates
canulates11312873canulates
casemates1349523casemates
caudates11310263caud_ates
hamates122917683ha__mates
handaxes1938403hand_axes
handmade1545963handmade_
handmaids1644543handmaids
inmates92715783_in_mates
landmarks1643613landmarks
landmass1144423landma_ss
landmasses1343213landmasses
mandate10315573mand_ate_
mandated12310293mand_ated
mandrakes1646353mandrakes
manducates1545593manducates
racemates1348853racemates
radiates92415293ra_diates
reanimates1247853reanimates
sanitates9611733sanitates
tannates81911953tan_nates
vanadates1345133vanadates
vanadiates1443743vanadiates
xanthates1945653xanthates

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 Filter1786911486410.453394461.4
2DLD Change Limit148641687.00021234.4
3Display Results68680.0302266.7
 (SQL Overall)178691687.48323879.6
 
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.