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

283 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
tartlets828966(None) 
martlets103310481martlets
partlets102811511partlets
tartlet72218481tartlet_
armlets94610062_armlets
artless73712512_artless
dartles84014132dartle_s
fartleks1533962fartleks
gantlets9308902gantlets
harslets1137832harslets
mantlets104611202mantlets
martlet93419152martlet_
partlet92720362partlet_
starlets81610082star_lets
startlers9236732startlers
startles82111962startle_s
tablets94714372ta_blets
tactless10288462tactless
targets84314222tar_gets
tartest72517532tart_est
tartiest82718312tartiest
tartness82210132tartness
tattlers8369692tattlers
tattles73616282tattle_s
turtlers8258202turtlers
turtles72914342turtle_s
varlets10411572var_lets
wartless11279922wartless
aglets73915683_a_glets
aiglets84012913_aiglets
amulets939923_amulets
anklets114310413_anklets
antlers74014743_antlers
applets115710063_applets
argles75218483_argle_s
arles56735743_ar_le_s
armets84918353_ar_mets
armless9369943_armless
armlet84118193_armlet_
artels66216233_art_els
artiest73121993_artiest
artists74215583_artists
auklets11298573_auklets
ballets93719513ba_llets
barbets114915843bar_bets
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
baronets101410903baronets
barrets94917103bar_rets
barters94223033bart_ers
battlers104110973battlers
battles94517683battle_s
bractlets1344753bractlets
cablets114216343ca_blets
callets93821703ca_llets
camlets114314623ca_mlets
cantles94721413cantle_s
capelets1268603capelets
caplets114914523ca_plets
careless102813633careless
carets85330773car__ets
carles85435083car_le_s
carless95118493car_less
carnets93918403car_nets
carolers103314173carolers
carpets113915333car_pets
cartels94618123cart_els
carters95327243cart_ers
cartes86239473cart_e_s
castles94917733castle_s
chartless1435703chartless
circlets1235663circlets
corslets1038273corslets
cutlets94113653_cutlets
darkles124011933darkle_s
darters84017603dart_ers
dartle73714833dartle__
dartled9409853dartle_d
eaglets84111663ea_glets
earless74316063ear_less
earthsets1244123earthsets
farles96025783far_le_s
farthest1499863farthest
fartlek1434493fartle_k
fatless103212203fa_tless
flatlets1147373flatlets
gallets83517403ga_llets
gantlet83616243gantlet_
garblers113810283garblers
garbles104016923garble_s
garbless11388253garbless
gargets94614573gar_gets
garglers10418263garglers
gargles94214893gargle_s
garnets84115403gar_nets
garrets84413623gar_rets
garters84218223gart_ers
gauntlets1042873gauntlets
gurglets10355543gurglets
haltless11308443haltless
hamlets123211403ha_mlets
hantles104117513hantle_s
harlots103413293har_lots
harmless1337403harmless
harslet10315653harslet_
haslets102510863ha_slets
hatless103813443ha_tless
heartless1236393heartless
hurtles103913753hurtle_s
hurtless11307783hurtless
kirtles11309663kirtle_s
mallets93318493ma_llets
mantelets1176813mantelets
mantles94820703mantle_s
mantlet93620993mantlet_
marblers12319233marblers
marbles114516653marble_s
markets133314033mar_kets
marplots1245633marplots
martens93714953mart_ens
martinets1138883martinets
mastless102610023mastless
matless93014043ma_tless
myrtles1235733myrtle_s
nutlets74111253_nutlets
oarless73913373oar_less
outlets73616363_outlets
palets85122313pa__lets
pallets93919303pa_llets
pantalets1147673pantalets
parapets1239763parapets
pargets105215193par_gets
parles86334393par_le_s
parleys125212373par_leys
parolees104313973parolees
paroles95025883parole_s
parquets1936413parquets
parsleys1335083parsleys
partiers103514243partiers
parties93230863partie_s
partners102711133partners
partyers13277763partyers
pastless102411203pastless
plantlets1145013plantlets
portless10310643portless
quartets17277573quart_ets
rattlers83510293rattlers
rattles73217303rattle_s
relets64025673__relets
rootlets8308653rootlets
sallets73719653sa_llets
saltless8259343saltless
samlets93813553sa_mlets
sarsnets836783sarsnets
scarlets10178573scar_lets
sparklets15275833sparklets
starets73515923star__ets
starless81610843star_less
starlet71620123star_let_
starters83714763start_ers
startle72511123startle__
startled9208553startle_d
startler8248783startle_r
sterlets8169273ster_lets
tabarets10287233tabarets
tables84524883ta_ble_s
tablet84227643ta_blet_
taborets10278063taborets
tackets134914363ta_ckets
tacklers143010773tacklers
tackles133816523tackle_s
tackless14419483tackless
tailers73720183ta_ilers
tailles72516463taille_s
tailless8239083tailless
taintless935733taintless
talents7312013ta__lents
talers64628143ta__lers
tales55451373ta__le_s
tallest7317093ta_llest
tallits73215993ta_llits
tamales93216143tamale_s
tameless10259903tameless
tanglers92911973tanglers
tangles83920043tangle_s
tankless12267823tankless
tapeless10218643tapeless
tappets113610013ta_ppets
tardies84225863tardie_s
tardiest93515243tardiest
tares57456563tar__e_s
targes74524593tar_ge_s
target75028903tar_get_
tarletan845543tar_letan
tarletans944643tar_letans
tarots66422993tar__ots
tarres64723043tar_re_s
tarriers83411713tarriers
tarries73324263tarrie_s
tarriest83215003tarriest
tarsiers8298533tarsiers
tartanas8258893tartanas
tartans72615823tart_ans
tartars73313403tart_ars
tarted74923373tart_e_d
tarter64023563tart_e_r
tartier74123263tartie_r
tartiness92112053tartiness
tartly96014023tartl__y
tartrate899673tartrate
tartrates979553tartrates
tarts57242023tar___ts
tartufes1164153tartufes
tarweeds1244273tarweeds
tassets75012773ta_ssets
tasteless935673tasteless
tasters74225643tast_ers
tastes64126423tast_e_s
tastiest83216633tastiest
taters64932193ta_t_ers
tates55444983ta_t_e_s
tatters74520483ta_tters
tatties74120343tattie_s
tattiest83415383tattiest
tattle64115653tattle__
tattled84311483tattle_d
tattler73112213tattle_r
tautens7317843taut_ens
tautest72612443taut_est
tautness8217183tautness
taxless1436903ta_xless
tearless848703tear_less
templets12226143templets
tentless8229843tentless
tercelets1144813tercelets
tercets93512443ter_cets
termless1036233termless
terrets72913573ter_rets
textless15245793textless
tintless8239863tintless
tireless82510263tireless
titles63719923t_itle_s
tittles73413253tittle_s
toilets74112913t_oilets
tonlets73212503t_onlets
tootlers8289503tootlers
tootles72915603tootle_s
tortes64826053tort_e_s
townlets1134773townlets
trailers82912913trailers
tramless1037503tramless
trawlers113310193trawlers
trawleys14284383trawleys
trawlnets1242843trawlnets
trets55928023t_r__ets
trevets10499973t_revets
trijets14308263t_rijets
triolets83410143triolets
triplets103510263triplets
trivets103911583t_rivets
turfless1135533turfless
turrets73010673tur_rets
turtle63213573turtle__
turtled8309683turtle_d
turtler72610323turtle_r
twattles1154383twattle_s
valets93715623va__lets
varlet9423503var_let_
wallets103914833wa_llets
warblers13319103warblers
warbles123215563warble_s
wardless12249303wardless
warless104015103war_less
warslers11328073warslers
warsles103413643warsle_s
warstlers12284713warstlers
warstles11368803warstle_s
wartiest113614643wartiest
wattles103814073wattle_s
wattless11268723wattless
wavelets1436153wavelets

Search took 10 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.1731032896.0
2DLD Change Limit1461622838.90616411.6
3Display Results2832830.1062669.8
 (SQL Overall)1786912839.18519454.7
 
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.