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

89 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
glassless104387(None) 
classless1143841classless
grassless1034301grassless
blissless1142632blissless
gasless8319012g_a_sless
glandless1134162glandless
glasses84414272glass_e_s
glassies94012272glassie_s
glassiest10279252glassiest
glassiness11245992glassiness
lossless835472_lossless
massless10277112_massless
passless10247222_passless
ashless10318453__ashless
assess65710463__ass_ess
baseless1099563_baseless
bassness1096743_bassness
bladeless1234303bladeless
blameless1334733blameless
cashless1336773_cashless
ceaseless1135733ceaseless
classers104111833class_ers
classes94717943class_e_s
classiest11309553classiest
classiness12196313classiness
clawless1334123cla_wless
crassness1136213crassness
feastless1235043feastless
flagless1235403fla_gless
flameless1435353flameless
flapless1335343fla_pless
flawless1434503fla_wless
fleshless1543993fleshless
gainless9117403g_ainless
gapless10349993g_a_pless
garbless11388253g_arbless
gassers84714633g_ass_ers
gasses75724783g_ass_e_s
gassiest93212523g_assiest
gassiness10268313g_assiness
gastness9278473g_astness
gateless9279953g_ateless
gearless937373gea_rless
gladness1036153gla_dness
glariness1038553glariness
glassed93710433glass_e_d
glassfuls13122813glassfuls
glassie8329493glassie__
glassier9289083glassie_r
glassines10278043glassines
glassmen1145393glassme_n
glaziness1935753glaziness
glebeless1242953glebeless
glossers9319053gloss_ers
glosses84014123gloss_e_s
glossies93311253glossie_s
glossiest10277943glossiest
glossiness11284983glossiness
goalless935723goa_lless
graceless12226893graceless
gradeless11236703gradeless
grainless1035893grainless
grasses84117343grass_e_s
grassiest10309513grassiest
grateless10277583grateless
graveless13226693graveless
greaseless1143483greaseless
grossness1045963grossness
gustless9287683g_ustless
hassles103411693_hassle_s
laceless10239853_laceless
landless94011173_landless
lasses64827593_lass_e_s
lassies74420103_lassie_s
lassoers8338513_lassoers
lassoes74613853_lassoe_s
lawless1037033_la_wless
lensless835583_lensless
listless8269263_listless
mastless102610023_mastless
pastless102411203_pastless
placeless1335613placeless
planless1036813pla_nless
playless1334863pla_yless
rassles73513923_rassle_s
reassess836513reass_ess
sashless1136603_sashless
wrassles11376713wrassle_s
yeastless1234053yeastless

Search took 7 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.436409841.7
2DLD Change Limit148641896.36023371.2
3Display Results89890.0461934.8
 (SQL Overall)178691896.84226116.8
 
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.