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

58 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
messmates134623(None) 
messmate1246391messmate_
messages1138232mess_ages
messuages1244392messuages
mismates121114562m_ismates
misstates11710632misstates
bedmates1349183be_dmates
casemates1349523casemates
cellmates1347513cellmates
classmates1444503classmates
decimates14410693decimates
desolates10311793desolates
despumates1543543despumates
estates74520183_e_states
estimates11911363_estimates
gemmates13307673ge_mmates
gestates93213733ge_states
helpmates1645513helpmates
hesitates1269793hesitates
hessites1138613hess_ites
massages1159883mass_ages
mediates112814063me_diates
medicates14312113medicates
meditates1239813meditates
mesdames1346043me_sdames
mesomeres1347193mesomeres
mesquites20476433mesquites
message1037833mess_age_
messaged1235543mess_aged
messans92710463mess_a_ns
messes84924343mess___es
messiahs1343963messia_hs
messman1137283messma__n
messmen1137393messm__en
messuage1144523messuage_
metates92720013me__tates
misdates111113633m_isdates
mismakes16129883m_ismakes
mismate111415353m_ismate_
mismated131111333m_ismated
misrates101318243m_isrates
misseated12610113misseated
misseats104011683misseat_s
misshapes1645913misshapes
misspaces1546513misspaces
misstate10711343misstate_
misstated1278973misstated
remates93827113re__mates
resinates9314763resinates
reslates83619503re_slates
resonates9412403resonates
restates83423433re_states
seatmates1157823seatmates
sensates8511143sens_ates
teammates1345673teammates
tesselates1043933tesselates
testates83615453te_states
vesicates14119033vesicates

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.423422437.4
2DLD Change Limit148641587.40620070.3
3Display Results58580.0134461.5
 (SQL Overall)178691587.84222786.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.