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

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

60 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
waterlessnesses1754721waterlessnesses_
waterlessness1653853waterlessne_s_s_
agelessnesses1387624_age_lessnesses_
airlessnesses12117994_a_irlessnesses_
carelessnesses1547724care_lessnesses_
cheerlessnesses1954544cheerlessnesses_
facelessnesses1847324face_lessnesses_
hairlessnesses16126634ha_irlessnesses_
namelessnesses1577054name_lessnesses_
pathlessnesses1855954pat_hlessnesses_
powerlessnesses1954494powerlessnesses_
statelessnesses1355864state_lessnesses_
tastelessnesses1355274taste_lessnesses_
waterishnesses2053164water_ishnesses_
witlessnesses1547234wit__lessnesses_
aimlessnesses1487465_a_imlessnesses_
artlessnesses1247665_a_rtlessnesses_
blamelessnesses1865715blame_lessnesses_
ceaselessnesses1596165cease_lessnesses_
colorlessnesses1665095colorlessnesses_
dauntlessnesses1554815dauntlessnesses_
deathlessnesses1885175deat_hlessnesses_
faithlessnesses2074975faithlessnesses_
faultlessnesses1754935faultlessnesses_
fearlessnesses1666745_fearlessnesses_
gracelessnesses1755905grace_lessnesses_
gutlessnesses1346945gut__lessnesses_
haplessnesses1747255ha__plessnesses_
harmlessnesses1876415ha_rmlessnesses_
heedlessnesses17136225_heedlessnesses_
homelessnesses18137475home_lessnesses_
hopelessnesses18147015hope_lessnesses_
humorlessnesses1954185humorlessnesses_
landlessnesses1456685la_ndlessnesses_
lawlessnesses1546385la__wlessnesses_
lifelessnesses1646655life_lessnesses_
lovelessnesses1646995love_lessnesses_
movelessnesses1846745move_lessnesses_
needlessnesses14115695_needlessnesses_
painlessnesses1546745pa_inlessnesses_
pitilessnesses1575755pit_ilessnesses_
raylessnesses1546505ra__ylessnesses_
ruthlessnesses1665385rut_hlessnesses_
saplessnesses1347275sa__plessnesses_
sexlessnesses1846745__sexlessnesses_
shamelessnesses18186515shame_lessnesses_
shapelessnesses18156295shape_lessnesses_
sleeplessnesses1554685sleeplessnesses_
tactlessnesses1546555ta_ctlessnesses_
timelessnesses1547025time_lessnesses_
tirelessnesses1357015__tirelessnesses_
tonelessnesses13137655tone_lessnesses_
toplessnesses1446585__toplessnesses_
uselessnesses1147315_use_lessnesses_
valuelessnesses1764795valuelessnesses_
waterinesses1567195water___inesses_
winglessnesses1765465w_inglessnesses_
wordlessnesses1775875w_ordlessnesses_
worklessnesses20125485w_orklessnesses_
worthlessnesses2054555worthlessnesses_

Search took 3 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 Filter178691435480.283631417.0
2DLD Change Limit43548602.26319243.5
3Display Results60600.0461304.3
 (SQL Overall)178691602.59268939.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.