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

115 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
charmless163358(None) 
chartless1435701chartless
harmless1337401_harmless
armless9369942__armless
careless102813632c_areless
carless95118492c_ar_less
chadless1436402cha_dless
chariness14310062chariness
charleys1695632char_leys
charmers154211332charm_ers
aimless93610813__aimless
armlets94610063__armlets
artless73712513__artless
barbless12318713_barbless
barkless14318023_barkless
barless94317003_bar_less
beamless12327003bea_mless
beardless1234913beardless
calmness1236643c_almness
camlets114314623c_a_mlets
capless114312763c_a_pless
caress85720263c_ar__ess
carles85435083c_ar_le_s
carolers103314173c_arolers
cashless1336773c_ashless
ceaseless1135733ceaseless
chalehs15268803cha__lehs
chalets122813473cha__lets
chambers173410623cha_mbers
chamfers18409223cha_mfers
chamises153513313cha_mises
chammies172910163chammie_s
champers173311623cha_mpers
chandlers15387673chandlers
changeless1643873changeless
chaplets1556883cha_plets
charades141310853charade_s
charases131312763charase_s
chares115631803char__e_s
chargers144011323char_gers
charges134615983char_ge_s
chariest13315513char_iest
charley15118273char_le_y
charlies133414233char_lies
charmed154714253charm_e_d
charmer144913663charm_e_r
charmeuse1642593charmeuse
charmeuses1743093charmeuses
charms135218843charm___s
charnels13328173char_nels
charriest1438263charriest
charters134115593char_ters
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
childless1543813childless
chimleys1883633ch_imleys
chinless1337493ch_inless
chorales133712883chorale_s
chortlers14305663chortlers
chortles133611323chortle_s
churchless20112493churchless
classless1143843classless
clawless1334123cla_wless
coalless1038193coa_lless
coatless1039693coa_tless
cordless11299963c_ordless
coreless103013833c_oreless
cureless10319703c_ureless
earless74316073_ear_less
fearless1137873fear_less
foamless13195843foa_mless
formless13248083_formless
garbless11388253_garbless
gearless937373gear_less
gormless11235443_gormless
hairless1157413_hairless
haltless11308443_haltless
hamlets123211403_ha_mlets
handless123512063_handless
hapless123311333_ha_pless
hardness122411083_hardness
harmers124116593_harm_ers
harmlessly1842783_harmlessly
harness102413933_har_ness
harslets1137833_harslets
hatless103813443_ha_tless
heartless1236393heartless
helmless1334273_helmless
herbless1336663_herbless
hornless1137363_hornless
hurtless11307783_hurtless
loamless10235213loa_mless
normless10235923_normless
oarless73913373_oar_less
scarless10189053scar_less
seamless10238723sea_mless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435573shapeless
sharpness1434943sharpness
shirtless12266413shirtless
shoreless1236633shoreless
starless81610843star_less
tearless848713tear_less
termless1036233_termless
thankless1633203thankless
thawless1434083tha_wless
thornless1243633thornless
tramless1037503tra_mless
wardless12249303_wardless
warless104015103_war_less
warmness1337063_warmness
wartless11279923_wartless
weariless1234763weariless

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 Limit1486411156.87621617.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.32824384.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.