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

145 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
grainless103589(None) 
brainless1136401brainless
gainless9117401g_ainless
rainless8129701_rainless
frailness1236542frailness
graceless12226892graceless
gradeless11236702gradeless
grainers93012072grain_ers
grainiest10188992grainiest
graininess1145792graininess
grapiness1238252grapin_ess
grassless1034302grassless
grateless10277582grateless
graveless13226692graveless
grayness1235932grayn_ess
painless10108342_painless
reinless8139432_reinless
stainless9176492stainless
trailless935962trailless
aidless83612073__aidless
aimless93610813__aimless
airless73712043__airless
artiness81615403artin_ess
awnless1035923__awnless
bractless1335543bractless
braillers1135553braillers
brailles1039493braille_s
brainiest11209723brainiest
braininess1246123braininess
brainlessly1652373brainlessly
brakeless1544993brakeless
braless92910563bra__less
brandless1236123brandless
brimless1235273br_imless
brineless1136243br_ineless
chinless1337493_chinless
craziness2037383crazin_ess
crownless1443423crownless
curtainless1351933curtainless
drabness1135803drabn_ess
drainers92811253drain_ers
dripless1135243dr_ipless
finless102810783__finless
frailest1139493frai_lest
frameless1435533frameless
fruitless1244163fruitless
gainers84214593g_ain_ers
gainliest1037133g_ainliest
gaminess112911063gamin_ess
gapless10349993g_a_pless
garbless11388253g_arbless
gasless8319013g_a_sless
gateless9279953g_ateless
gayness1136843g_ayn_ess
gearless937373gea_rless
germiness1257693germin_ess
giantess933893gia_ntess
gladness1036153gladn_ess
glandless1134163glandless
glariness1038553glarin_ess
glassless1043873glassless
glaziness1935753glazin_ess
gluiness937363gluin_ess
goalless935723goa_lless
goriness9310753gorin_ess
grabblers14345513grabblers
grabbles13339893grabble_s
graciles112511613gracile_s
grackles15309183grackle_s
gradines103615253gradin_e_s
grails77518783grai_l__s
grained93814273grain_e_d
grainer83714063grain_e_r
grainier9218903grainie_r
grains74223093grain___s
grandees103211283gra_ndees
grandest10311573gra_ndest
grandness1138303grandness
grangers103011973gra_ngers
granges93516523gra_nge_s
granites92116363granite_s
grannies9312613grannie_s
grantees92510973gra_ntees
granters93614143gra_nters
granules939933granule_s
grapnels1134393grapn_els
grapplers14274303grapplers
grapples13348123grapple_s
gratinees10307323gratin_ees
graveness13288383graveness
greaseless1143483greaseless
greasiness1156543greasin_ess
greatness1036903greatn_ess
greedless1144893greedless
greenlets1044703greenlets
greenness1046793greenness
greyness1235243greyn_ess
grillers93810813gr_illers
grilles83715023gr_ille_s
grilses8319153gr_i_lses
griminess1236703grimin_ess
grimness1175993gr_imness
grinders103410423gr_inders
grinners9288043gr_inners
groundless1243473groundless
groveless13235363groveless
gunless8299633g__unless
hairless1157413_hairless
kinless113310273__kinless
mailless10248583_mailless
manless93012933_ma_nless
plainness1155183plainness
planless1036813pla_nless
princess12266803pr_incess
printless1137513pr_intless
raciness102413453_racin_ess
railers74420663_rai_lers
rainiest81214923_rainiest
raininess949273_raininess
rankless12268233_rankless
rawness1038153_rawn_ess
rayless10239003_ra_yless
ribless93410343_r_ibless
rimless9369363_r_imless
rindless92510193_r_indless
runless72810423_r_unless
sailless82410373_sailless
sinless73014213__sinless
skinless12216973_skinless
spanless10247363spa_nless
spinless10238703_spinless
stairless9185623stairless
tailless8239083_tailless
taintless935733_taintless
traceless11228643traceless
trackless15246723trackless
trailers82912923trai_lers
trainees82712063train_ees
trainers83114643train_ers
traitress944403traitress
tramless1037503tra_mless
vainness1136063_vainness
veinless11136263_veinless
wariness11313213warin_ess
winless103212283__winless

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.406440125.6
2DLD Change Limit1486411456.90621523.5
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.37524229.3
 
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.