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

184 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
keelless1223619(None) 
heelless11257651heelless
beefless1335492beefless
deedless10318252deedless
feeless103511102fee_less
feetless1137382feetless
heedless12278812heedless
keenness1234882keenness
keyless1436162k_eyless
mealless10288362mealless
needless9308332needless
peerless1037512peerless
seedless9319512seedless
weedless12287962weedless
wheelless1543762wheelless
ageless8310343age_less
aweless1038723awe_less
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bedless1039703_bedless
beetlers1037393beetlers
beetles9312083beetle_s
belles85325993_belle_s
beltless10297713beltless
bevellers14276113bevellers
bowelless1443833bowelless
cheekless1873883cheekless
cheerless1495293cheerless
coalless1038193coalless
crewless1335403crewless
debtless1135653debtless
deepness1136443deepness
dewless1137473_dewless
duellers9268223duellers
dwellers12356083dwellers
earless74316073_earless
eeliest73516473_eeliest
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fearless1137873fearless
feckless17225783feckless
feeblest1336913feeblest
feelers103814743fee_lers
fellers104117543_fellers
fellest10313753_fellest
fellness1135913fellness
fernless1136063fernless
fretless1138063fretless
fuellers11277983fuellers
gearless937373gearless
goalless935723goalless
greedless1144893greedless
headless12289863headless
heatless113011463heatless
heelers103815623hee_lers
heirless1146053heirless
hellers103619833_hellers
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
holeless1189363holeless
hueless1058823hue_less
iceless9219963ice_less
idealess935653idealess
idealless1042953idealless
ireless72312243ire_less
isleless834853isleless
jewellers1943533jewellers
keckles12318763keckle_s
keelages1335743keelages
keeled114414263kee_le_d
keelhales1662953keelhale_s
keels94622413kee_l__s
keelsons1244093keelsons
keeners113610783kee_ners
keenest11410963kee_nest
keepers133410983kee_pers
keesters12319593keesters
keeves133711983kee_ve_s
kegelers1355163kegelers
keglers12277773k_eglers
keleps12478813k_e_leps
kellies113516853k_ellies
kelters113813753k_elters
kermess13396223k_ermess
kettles113411613kettle_s
killers114215583k_illers
kindless13289243kindless
kingless13288693kingless
kinless113310273k_inless
kneelers12226213kneelers
knelled12338983knelle_d
knells10439253knell__s
knollers12255133knollers
knotless1264563knotless
krullers1234133krullers
kvelled15276063kvelle_d
kvells13346613kvell__s
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013_legless
lensless835583lensless
levellers12286043levellers
levelness1245453levelness
mailless10248583mailless
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
neckless14236433neckless
needlers9287423needlers
needles83211563needle_s
netless739863_netless
newsless1134533newsless
peakless14236683peakless
peelers93615593pee_lers
peeress939503pee_ress
pegless1038053_pegless
pellets94014783_pellets
peltless10267373peltless
phellems1544543phellems
pileless1088623pileless
poetless1038723poetless
poleless1089873poleless
prebless1236823prebless
quellers17237533quellers
realness8410443realness
reckless14257973reckless
reelers73520273ree_lers
reinless8139433reinless
repellers11278873repellers
resellers9299903resellers
restless82713163restless
revellers12319503revellers
ruleless836633ruleless
sailless82410373sailless
seamless10238723seamless
seatless83213003seatless
seeress7311573see_ress
selfless1135013selfless
sellers73721313_sellers
selles64426983_selle_s
sewerless1244303sewerless
sexless1467243_sexless
sheetless1235823sheetless
shellers112812573shellers
skilless12246763skilless
sleepless1144553sleepless
smellers10329763smellers
snellest839483snellest
soilless8279033soilless
soleless8910033soleless
soulless8218763soulless
spellers102812753spellers
stemless1036653stemless
swellest1137663swellest
tailless8239083tailless
tearless848713tearless
teethless1243703teethless
tellers73717593_tellers
tentless8229843tentless
termless1036233termless
textless15245793textless
thewless1433923thewless
tieless72512563tie_less
toeless72612393toe_less
toolless836343toolless
treeless839283treeless
ukeleles1252663ukelele_s
useless7188423use_less
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
viewless1434033viewless
webless1237003_webless
weldless12285813weldless
wellness1135793wellness
whelpless1742053whelpless
yellers103912953_yellers
zestless17247433zestless

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621846.59322169.3
3Display Results1841840.0762421.1
 (SQL Overall)1786911846.82526181.8
 
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.