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

159 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
fartleks153396(None) 
fartlek1434491fartlek_
artless73712512_artless
dartles84014132dartle_s
farles96025782far_le_s
fatless103212202fa_tless
martlets103310482martlets
partlets102811512partlets
tartlets8289662tartlets
wartless11279922wartless
antlers74014743_antlers
argles75218483_argle_s
arles56735743_ar_le_s
armless9369943_armless
armlets94610063_armlets
artels66216233_art_els
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
barters94223033bart_ers
battlers104110973battlers
battles94517683battle_s
cantles94721413cantle_s
careless102813633careless
carles85435083car_le_s
carless95118493car_less
carolers103314173carolers
cartels94618123cart_els
carters95327253cart_ers
cartes86239473cart_e_s
castles94917733castle_s
chartless1435703chartless
darkles124011933darkle_s
darters84017603dart_ers
dartle73714833dartle__
dartled9409853dartle_d
earless74316073ear_less
fablers124812613fa_blers
fables114921673fa_ble_s
faceless13269173faceless
fadeless12258323fadeless
failles102914133faille_s
faithless1543903faithless
fallers103917993fa_llers
falters103916473falt_ers
fameless13259203fameless
fangless1237663fangless
farcers124713443far_cers
farces115223323far_ce_s
farcies125317883farcie_s
fardels11389893far_dels
farers95924053far__ers
fares85852873far__e_s
farfels13348213far_fels
farle86929243far_le__
farls85731113far_l__s
farmers124315263far_mers
farness102912203far_ness
farriers113610743farriers
farted105121783fart_e_d
farther1348343farthe_r
farthest1499863farthest
farts88336843fart___s
fastens105511753fast_ens
fastness11238763fastness
fates85139233fa_t_e_s
fathers133916503fa_thers
fatlike142911193fa_tlike
fatness103311293fa_tness
fattens105111713fa_ttens
fatties103018203fattie_s
faultless1243163faultless
fearless1137873fear_less
feastless1235043feastless
feetless1137383feetless
fernless1136063fernless
ferules103112723ferule_s
fettles103912733fettle_s
fireless112810593fireless
flatlets1147373flatlets
footlers113910793footlers
footles103715713footle_s
footless113710803footless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
fortes95327183fort_e_s
forties104323863fortie_s
fortress1136753fortress
fraters103517213frat_ers
fretless1138063fretless
furlers104214223fur_lers
furless103210143fur_less
furthers1436493furthers
gantlets9308903gantlets
garblers113810283garblers
garbles104016923garble_s
garbless11388253garbless
garglers10418263garglers
gargles94214893gargle_s
garters84218233gart_ers
haltless11308443haltless
hantles104117513hantle_s
harmless1337403harmless
harslets1137833harslets
hatless103813443ha_tless
heartless1236393heartless
hurtles103913753hurtle_s
hurtless11307783hurtless
kirtles11309663kirtle_s
mantles94820703mantle_s
mantlets104611203mantlets
marblers12319233marblers
marbles114516653marble_s
martens93714953mart_ens
martlet93419153martle_t
mastless102610023mastless
matless93014043ma_tless
myrtles1235733myrtle_s
oarless73913373oar_less
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
parsleys1335083parsleys
partakes1449923partakes
partiers103514243partiers
parties93230863partie_s
partlet92720363partle_t
partners102711133partners
partyers13277763partyers
pastless102411203pastless
portless10310643portless
rattlers83510293rattlers
rattles73217303rattle_s
saltless8259343saltless
startlers9236743startlers
startles82111963startle_s
tactless10288463tactless
tartlet72218483tartle_t
tartness82210133tartness
tattlers8369693tattlers
tattles73616283tattle_s
turtlers8258203turtlers
turtles72914343turtle_s
varlets10411573var_lets
warblers13319103warblers
warbles123215563warble_s
wardless12249303wardless
warless104015103war_less
warslers11328073warslers
warsles103413643warsle_s
warstlers12284713warstlers
warstles11368803warstle_s
wartlike1537043wartlike
wattles103814073wattle_s
wattless11268723wattless

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621596.59322169.3
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.07625253.1
 
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.