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 “grassless” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
grassless103430(None) 
glassless1043871glassless
classless1143842classless
crassness1136212crassness
gasless8319012g_a_sless
graceless12226882graceless
gradeless11236702gradeless
grainless1035882grainless
grasses84117342grass_e_s
grassiest10309512grassiest
grateless10277572grateless
graveless13226692graveless
greaseless1143482greaseless
grossness1045962grossness
massless10277112_massless
passless10247222_passless
rassles73513922_rassle_s
wrassles11376712wrassle_s
ashless10318453__ashless
assess65710463__ass_ess
baseless1099563_baseless
bassness1096743_bassness
blissless1142623blissless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
braless92910563bra__less
brandless1236123brandless
brashness1436323brashness
brasses93818353brass_e_s
brassies103613533brassie_s
brassiest11369713brassiest
brassiness1235483brassiness
brushless1444003brushless
cashless1336773_cashless
ceaseless1135733ceaseless
crassest103411523crass_est
creaseless1243643creaseless
crestless1146783crestless
crosslets1145183crosslets
crossness1137093crossness
crustless1155393crustless
feastless1235043feastless
frameless1435533frameless
frasses104314513frass_e_s
frostless1235743frostless
gainless9117403g_ainless
gapless10349993g_a_pless
garbless11388253g_arbless
gassers84714633g_ass_ers
gasses75724783g_ass_e_s
gassiest93212523g_assiest
gassiness10268313g_assiness
gastness9278473g_astness
gateless9279953g_ateless
gearless937363gea_rless
girasoles1083713girasole_s
glandless1134163glandless
glasses84414273glass_e_s
glassies94012273glassie_s
glassiest10279243glassiest
glassiness11245993glassiness
goalless935723goa_lless
grabblers14345513grabblers
grabbles13339893grabble_s
graciles112511613gracile_s
grackles15309183grackle_s
grandness1138303grandness
granules939933granule_s
grapiness1238243grapiness
grapplers14274303grapplers
grapples13348123grapple_s
graspers11338393gra_spers
grassed93812793grass_e_d
grassier9349283grassie_r
grassland1153473grassland
grasslands1243083grasslands
grasslike1443693grasslike
grassplots1351683grassplots
graveness13288383graveness
grayness1235933gra_yness
greasiness1156533greasiness
greedless1144893greedless
gristles9189203gristle_s
grossers94410973gross_ers
grosses84517683gross_e_s
grossest93810093gross_est
groveless13235363groveless
gustless9287683g_ustless
hassles103411693_hassle_s
lossless835473_lossless
mastless102610023_mastless
pastless102411203_pastless
rainless8129703_rainless
rankless12268233_rankless
rashness1138093_rashness
rassle63813203_rassle__
rassled83310443_rassle_d
rayless10239003_ra_yless
reassess836513reass_ess
restless82713163_restless
riskless1235763_riskless
rustless83510233_rustless
sashless1136603_sashless
stressless942743stressless
traceless11228643traceless
trackless15246723trackless
trailless935963trailless
tramless1037503tra_mless
trasses74819323trass_e_s
trustless955933trustless
wrasses103812593wrass_e_s
wrassle10357173wrassle__
wrassled12325373wrassle_d
wrastles11328933wrastle_s
yeastless1234053yeastless

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.1561145455.1
2DLD Change Limit1486411167.67319372.0
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.87522690.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.