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

246 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
harslets113783(None) 
harslet10315651harslet_
haslets102510861ha_slets
armlets94610062_armlets
corslets1038272corslets
hamlets123211402ha_mlets
harlots103413292har_lots
harmless1337402harmless
harshens1437602harshens
harshest14310192harshest
haslet93222712ha_slet_
hassles103411692hassle_s
hirsles101510072hirsle_s
martlets103310482martlets
parsleys1335082parsleys
partlets102811512partlets
sarsnets836782sarsnets
tartlets8289662tartlets
varlets10411572var_lets
warslers11328072warslers
warsles103413642warsle_s
aglets73915683_a_glets
aiglets84012913_aiglets
aisles64721143_aisle_s
amulets939923_amulets
anklets114310413_anklets
applets115710063_applets
argles75218483_argle_s
arles56735743_ar_le_s
armets84918353_ar_mets
armless9369943_armless
armlet84118193_armlet_
arses55733873_ars_e_s
artless73712513_artless
assets65617663_a_ssets
auklets11298573_auklets
ballets93719513ba_llets
barbets114915843bar_bets
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
baronets101410903baronets
barrets94917103bar_rets
baskets135111833ba_skets
bassets96414823ba_ssets
cablets114216343ca_blets
callets93821703ca_llets
camlets114314623ca_mlets
capelets1268603capelets
caplets114914523ca_plets
careless102813633careless
carets85330773car__ets
carles85435083car_le_s
carless95118493car_less
carnets93918403car_nets
carolers103314173carolers
carpets113915333car_pets
carses85233653cars_e_s
caskets133910173ca_skets
chalets122813473cha__lets
chaplets1556883cha_plets
charleys1695633char_leys
charmless1633573charmless
chartless1435703chartless
circlets1235663circlets
corselets1147313corselets
corsets94819803cors_ets
corslet9318063corslet_
darkles124011933darkle_s
dartles84014133dartle_s
eaglets84111663ea_glets
earless74316063ear_less
earshots1146623earshots
farles96025783far_le_s
fartleks1533963fartleks
gallets83517403ga_llets
gantlets9308903gantlets
garblers113810283garblers
garbles104016923garble_s
garbless11388253garbless
gargets94614573gar_gets
garglers10418263garglers
gargles94214893gargle_s
garnets84115403gar_nets
garrets84413623gar_rets
gaskets12348153ga_skets
gasless8319013ga_sless
gurglets10355543gurglets
hacklers173710303hacklers
hackles162917063hackle_s
haets86525123ha___ets
haffets1636053ha_ffets
hagglers13326623hagglers
haggles123312483haggle_s
hailers104017263ha_ilers
hairless1157413hairless
hairnets1195633hairnets
halers94926913ha__lers
hales85449843ha__le_s
halest94823273ha__lest
hallels103310133ha_llels
haltless11308443haltless
halts85230103ha__l_ts
hamlet113722793ha_mlet_
hamsters13710423hamsters
handlers124014143handlers
handles114020653handle_s
handless123512063handless
handsets12258343handsets
hansels104011653hans_els
hanses95022633hans_e_s
hantles104117513hantle_s
haoles94919803ha_ole_s
hapless123311333ha_pless
harassers1246193harassers
harasses11311033harasse_s
hardens113815023har_dens
hardest113118413har_dest
hardhats1546833hardhats
hardies114923233hardie_s
hardiest123416333hardiest
hardness122411083hardness
hardset113415833hardset_
hareems12428203har_eems
harelips1345213harelips
harems115513823har__ems
hares86255543har__e_s
haricots1347333haricots
harkens144112863har_kens
harlot94422803har_lot_
harls85634503har_l__s
harmers124116593har_mers
harness102413933har_ness
harpers124916203har_pers
harpies123818313harpie_s
harpists1338093harpists
harriers113712433harriers
harries103525493harrie_s
harshen1339283harshe_n
harsher13310363harshe_r
harshness1545963harshness
harts88441593har___ts
harvest132112753har_vest
harvests14246173harvests
hashes125024803ha_she_s
hassels104311013ha_ssels
hassle93711593hassle__
hassled11358303hassle_d
hastens106214813ha_stens
hastes95727073ha_ste_s
hatchets163310383hatchets
hatless103813443ha_tless
haulers104012443ha_ulers
hausens1077633haus_ens
hawsers13409483haws_ers
hawses125113993haws_e_s
hayseeds1543283hayseeds
headsets1236053heads_ets
hearses104414533hears_e_s
heartless1236393heartless
herbless1336663herbless
hirples12149643hirple_s
hirsels10128343hirs_els
hirsle9159573hirsle__
hirsled11118113hirsle_d
hoarsens11306023hoars_ens
hoarsest1137133hoars_est
hooklets15217203hooklets
hornets104113553hor_nets
hornless1137363hornless
horseless1237213horseless
horses94729343hors_e_s
horsiest112513263horsiest
horstes104516113horste_s
horsts95817513hors__ts
howlets13329223h_owlets
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurlers103714323hur_lers
hurleys13407333hur_leys
hursts97213093hurs__ts
hurtles103913753hurtle_s
hurtless11307783hurtless
islets64513083__islets
karsts106012943kars__ts
mallets93318493ma_llets
mantlets104611203mantlets
marblers12319233marblers
marbles114516653marble_s
markets133314033mar_kets
marplots1245633marplots
marses84827113mars_e_s
marshes123615373marshe_s
martlet93419153martlet_
massless10277113massless
nailsets834553nailsets
oarless73913373oar_less
paisleys1333343paisleys
palets85122313pa__lets
pallets93919303pa_llets
parapets1239763parapets
pargets105215193par_gets
parles86334393par_le_s
parleys125212373par_leys
parolees104313973parolees
paroles95025883parole_s
parquets1936413parquets
parsecs11429913pars_ecs
parsers94118153pars_ers
parses85534703pars_e_s
parsley1247793parsle_y
partlet92720363partlet_
passless10247223passless
rassles73513923rassle_s
relets64025673__relets
sallets73719653sa_llets
samlets93813553sa_mlets
sarsenets946513sarsenets
sarsens7311393sars_ens
sarsnet7314813sarsnet_
scarlets10178573scar_lets
sparklets15275833sparklets
starlets81610083star_lets
tablets94714373ta_blets
targets84314223tar_gets
tarsiers8298533tarsiers
tartlet72218483tartlet_
tassets75012773ta_ssets
valets93715623va__lets
varlet9423503var_let_
versets103913093vers_ets
wadsets1136443wads_ets
wallets103914833wa_llets
warblers13319103warblers
warbles123215563warble_s
wardless12249303wardless
warless104015103war_less
warsle93112923warsle__
warsled112910443warsle_d
warsler10289893warsle_r
warstlers12284713warstlers
warstles11368803warstle_s
wartless11279923wartless
wavelets1436153wavelets
worsets105512843wors_ets

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 Limit1461622466.39022873.6
3Display Results2462460.0962562.5
 (SQL Overall)1786912466.64226903.2
 
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.