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

161 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
chartless143570(None) 
charmless1633581charmless
artless73712512__artless
careless102813632c_areless
carless95118492c_ar_less
chadless1436402cha_dless
chariness14310062chariness
charleys1695632char_leys
charters134115582chart_ers
chortlers14305662chortlers
chortles133611322chortle_s
coatless1039692coa_tless
haltless11308442_haltless
harmless1337402_harmless
hatless103813442_ha_tless
heartless1236392heartless
hurtless11307782_hurtless
shirtless12266412shirtless
wartless11279922_wartless
apartness1146053apartness
armless9369943__armless
barbless12318713_barbless
barkless14318023_barkless
barless94317003_bar_less
beardless1234913beardless
beatless103311593bea_tless
bractless1335543bractless
cantles94721413c_antle_s
capless114312763c_a_pless
caress85720263c_ar__ess
carles85435083c_ar_le_s
carolers103314173c_arolers
cartels94618123c_art_els
carters95327253c_art_ers
cartes86239473c_art_e_s
cashless1336773c_ashless
castles94917733c_astle_s
ceaseless1135733ceaseless
chalehs15268803cha__lehs
chalets122813473cha__lets
chandlers15387673chandlers
changeless1643873changeless
chanters134016743chant_ers
chanteys16387493chant_eys
chanties132615803chantie_s
chaplets1556883cha_plets
chapters154012133chapt_ers
charades141310853charade_s
charases131312763charase_s
chares115631803char__e_s
chargers144011323char_gers
charges134615983char_ge_s
chariest13315513char_iest
charities14312743charitie_s
charley15118273char_le_y
charlies133414233char_lies
charmers154211333char_mers
charnels13328173char_nels
charriest1438263charriest
charted135116853chart_e_d
charter123918303chart_e_r
charterers15146053charterers
chartist131112133chart_ist
chartists14126803chartists
chartreuse1551943chartreuse
chartreuses1652213chartreuses
charts115823093chart___s
chasteness1546523chasteness
chastens13429183chast_ens
chastest1349703chast_est
chastises1437703chastises
chattels13286793cha_ttels
chatters134213953cha_tters
chattiest1448213chattiest
chattiness1565123chattiness
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
chertiest1438793chertiest
childless1543813childless
chinless1337493ch_inless
chorales133712883chorale_s
chortens13308793chort_ens
chortle124210443chortle__
chortled14326613chortle_d
chortler13336843chortle_r
churchless20112493churchless
classless1143843classless
clawless1334123cla_wless
coalless1038193coa_lless
cordless11299963c_ordless
coreless103013833c_oreless
costless10310003c_ostless
countless1146373countless
crestless1146783crestless
crustless1155403crustless
cureless10319703c_ureless
curtness1037263c_urtness
dartles84014133_dartle_s
earless74316073_ear_less
fartleks1533963_fartleks
fatless103212203_fa_tless
fearless1137873fear_less
feastless1235043feastless
garbless11388253_garbless
gearless937373gear_less
hairless1157413_hairless
handless123512063_handless
hantles104117513_hantle_s
hapless123311333_ha_pless
hardness122411083_hardness
harness102413933_har_ness
harslets1137833_harslets
heatless113011463_heatless
herbless1336663_herbless
hiltless11297123_hiltless
hitless103211193_h_itless
hornless1137363_hornless
hurtles103913753_hurtle_s
martlets103310483_martlets
mastless102610023_mastless
matless93014043_ma_tless
meatless103410863mea_tless
oarless73913373_oar_less
partlets102811513_partlets
pastless102411203_pastless
peartness1137773peartness
portless10310643_portless
saltless8259343_saltless
scarless10189053scar_less
seatless83213003sea_tless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435573shapeless
sharpness1434943sharpness
sheetless1235823sheetless
shiftless15265303shiftless
shitless11249243sh_itless
shoreless1236633shoreless
shortness1236733shortness
skirtless13254423skirtless
smartness1136143smartness
starless81610843star_less
startlers9236743startlers
startles82111963startle_s
swartness1236113swartness
tactless10288463_tactless
tartlets8289663_tartlets
tartness82210133_tartness
tearless848713tear_less
thankless1633203thankless
thawless1434083tha_wless
thornless1243633thornless
wardless12249303_wardless
warless104015103_war_less
wattless11268723_wattless
weariless1234763weariless
whatness1435093wha_tness
wheatless1534003wheatless
whortles14306743whortle_s
yeastless1234053yeastless

Search took 9 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 Limit1486411617.53319732.0
3Display Results1611610.0762118.4
 (SQL Overall)1786911618.04522211.4
 
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.