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

73 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
menseless114520(None) 
senseless945971senseless
ceaseless1135732ceaseless
denseness1046862denseness
fenceless1444162fenceless
lensless835582lens_less
maneless102812342man_eless
tenseness947112tenseness
baseless1099563_baseless
benchless1644153benchless
boneless10310213bon_eless
causeless1135193causeless
centerless1245003centerless
creaseless1243643creaseless
defenseless1551893defenseless
edgeless1034883_edgeless
endless839833_en_dless
ensiles72714833_ensile_s
eyeless1058053_e_yeless
feastless1235043feastless
feeless103511103fe__eless
fenderless1443533fenderless
fuseless11237233_fuseless
greaseless1143483greaseless
horseless1237213horseless
houseless1237463houseless
immenseness1553133immenseness
lineless82711943lin_eless
manless93012933man__less
mannerless1243523mannerless
mantelets1176813mantelets
massless10277113m_assless
mastless102610023m_astless
mateless102711293m_ateless
mealless10288363me_alless
measles92412753meas_le_s
measureless1371733measureless
meatless103410863me_atless
mensches1536303mensche_s
menses84222453mens__e_s
menshes12310453mens_he_s
mentalese1146323mentalese
mentaleses1245953mentaleses
mentees93214503mente_e_s
merciless1344473merciless
meritless1144593meritless
meseems1165603me_se_ems
messiness11248223messiness
mindless11319443min_dless
moneyless1444653moneyless
moveless1367753m_oveless
nerveless1243933nerveless
newsless1134533news_less
noiseless945553noiseless
noseless839513_noseless
offenseless1751353offenseless
paneless102611763pan_eless
penniless1144013penniless
pensees9311203pense_e_s
restless82713163re_stless
senselessly1472613senselessly
teaselers9165843teaselers
tentless8229843ten_tless
terseness948403terseness
toneless8610393ton_eless
tuneless837913tun_eless
useless7188423__useless
ventless11249053ven_tless
vestless11258843ve_stless
wineless112711173win_eless
yeastless1234053yeastless
zestless17247433ze_stless
zoneless1737823zon_eless

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 Limit148641736.89021573.4
3Display Results73730.0461587.0
 (SQL Overall)178691737.38924183.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.