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

353 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
tartlet7221848(None) 
martlet93419151martlet
partlet92720361partlet
tartlets8289661tartlets
armlet84118192_armlet
dartle73714832dartle_
dartled9409852dartled
dartles84014132dartles
fartlek1434492fartlek
gantlet83616242gantlet
harslet10315652harslet
mantlet93620992mantlet
martlets103310482martlets
partlets102811512partlets
starlet71620122star_let
startle72511122startle_
startled9208552startled
startler8248782startler
startles82111962startles
tablet84227642ta_blet
target75028902tar_get
tarted74923372tart_ed
tarter64023562tart_er
tartest72517532tartest
tartier74123262tartier
tartiest82718312tartiest
tartly96014022tartl_y
tattle64115652tattle_
tattled84311482tattled
tattler73112212tattler
tattles73616282tattles
turtle63213572turtle_
turtled8309682turtled
turtler72610322turtler
turtles72914342turtles
varlet9423502var_let
aglet65534143_a_glet
aiglet74224193_aiglet
amulet8419573_amulet
anklet105618733_anklet
antler64615553_antler
applet105917433_applet
argle65421563_argle_
argled85314543_argled
argles75218483_argles
ariled75620323_ariled
arles56735743_ar_les
armet76739453_ar_met
armlets94610063_armlets
artel56122743_art_el
artels66216233_artels
artier63419733_artier
artiest73121993_artiest
artist64125543_artist
artless73712513_artless
auklet104216833_auklet
ballet84733973ba_llet
barbet104427883bar_bet
barley115116763bar_ley
baronet91022203baronet
barret84930483bar_ret
barter85525373bart_er
battle85217863battle_
battled104213123battled
battler94113383battler
battles94517683battles
bractlet1239283bractlet
cablet104429463ca_blet
callet84536763ca_llet
camlet104426583ca_mlet
cantle84522153cantle_
cantles94721413cantles
capelet11517073capelet
caplet104226813ca_plet
caret75360563car__et
carle74535703car_le_
carles85435083car_les
carnet84732873car_net
caroled103717683caroled
caroler93816753caroler
carpet104530093car_pet
carte75940423cart_e_
carted98631443cart_ed
cartel85022533cart_el
cartels94618123cartels
carter84932273cart_er
cartes86239473cart_es
castle84918963castle_
castled104311513castled
castles94917733castles
cattle85118903cattle_
circlet11311473circlet
corslet9318063corslet
cutlet84924363_cutlet
darkle113813943darkle_
darkled13378713darkled
darkles124011933darkles
darted84620923dart_ed
darter75320363dart_er
eaglet73722583ea_glet
earthed1139923earthed
earthen1039253earthen
earthset11410823earthset
farle86929243far_le_
farles96025783far_les
farted105121783fart_ed
farther1348343farther
farthest1499863farthest
fartleks1533963fartleks
flatlet10312253flatlet
gallet73630853ga_llet
gantlets9308903gantlets
garble94118453garble_
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
garget84327273gar_get
gargle84215463gargle_
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
garnet73928413gar_net
garret74426553gar_ret
garter74420513gart_er
gauntlet955903gauntlet
gurglet94412033gurglet
hamlet113722793ha_mlet
hantle94318203hantle_
hantles104117513hantles
hardset113415833hardset
harlot94422803har_lot
harslets1137833harslets
haslet93222713ha_slet
hurtle93512943hurtle_
hurtled11339593hurtled
hurtles103913753hurtles
kirtle10309473kirtle_
kirtled12287033kirtled
kirtles11309663kirtles
mallet84433053ma_llet
mantelet10613823mantelet
mantle84420923mantle_
mantled104113393mantled
mantles94820703mantles
mantlets104611203mantlets
marble104219103marble_
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
market123226043mar_ket
marled95523163mar_led
marplot1149673marplot
marted94425213mart_ed
marten84518263mart_en
martinet10319643martinet
myrtle1135733myrtle_
myrtles1235733myrtles
narthex1734263narthex
nutlet64220563_nutlet
outlet63728683_outlet
palet74650803pa__let
pallet84232653pa_llet
pantalet10415903pantalet
parapet11317643parapet
parget94529393par_get
parle75836163par_le_
parled94626273par_led
parles86334393par_les
parley116718353par_ley
parole84425253parole_
paroled104217613paroled
parolee94119633parolee
paroles95025883paroles
parquet18311583parquet
parsley1247793parsley
parted94228683part_ed
partied103516553partied
partier93520713partier
parties93230863parties
partite9317133partite
partly116315473partl_y
partner92811393partner
partyer12337873partyer
plantlet10310013plantlet
quartet162814893quart_et
rattle64717613rattle_
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
relet54749823__relet
rootlet73015733rootlet
sallet63734543sa_llet
samlet84126563sa_mlet
sarsnet7314813sarsnet
scarlet91516943scar_let
sparklet143110583sparklet
starlets81610083star_lets
starlit71512913star_lit
started84217323start_ed
starter73817873start_er
startlers9236733startlers
sterlet71318473ster_let
tabaret92717313tabaret
table75429603ta_ble_
tabled94020043ta_bled
tables84524883ta_bles
tablets94714373ta_blets
taboret92916113taboret
tacet75840023ta__cet
tacket124627493ta_cket
tackle123815733tackle_
tackled143913183tackled
tackler134013323tackler
tackles133816523tackles
tactile9310613tactile_
tactless10288463tactless
tailed74424663ta_iled
tailer63823733ta_iler
taille63116923taille_
tailles72516463tailles
tale46154163ta__le_
talent6323323ta__lent
taler56034863ta__ler
tales55451373ta__les
taller63721963ta_ller
tallest7317093ta_llest
tallit63422733ta_llit
tamale83717393tamale_
tamales93216143tamales
tangle74019953tangle_
tangled94214633tangled
tangler83515073tangler
tangles83920043tangles
tappet103820113ta_ppet
tardier859719993tardier
tardies84225863tardies
tardiest93515243tardiest
tare45957623tar__e_
tared69340053tar__ed
tares57456563tar__es
targe65227093tar_ge_
targes74524593tar_ges
targets84314223tar_gets
tarletan845543tar_letan
tarot55943933tar__ot
tarre55825633tar_re_
tarred74720283tar_red
tarres64723043tar_res
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarriest83215003tarriest
tarsier74119253tarsier
tart47566183tar___t
tartan64217513tart_an
tartana73010193tartana
tartans72615823tartans
tartar63214753tart_ar
tartare73012683tartare
tartars73313403tartars
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tartness82210133tartness
tartrate899673tartrate
tarts57242023tart__s
tartufe1064673tartufe
tartufes1164153tartufes
tarty86328183tart__y
tarweed1137343tarweed
tasset65925313ta_sset
taste55127233tast_e_
tasted74123973tast_ed
taster64930573tast_er
tastes64126423tast_es
tastier711817093tastier
tastiest83216633tastiest
tate44748603ta_t_e_
tater54138613ta_t_er
tates55444983ta_t_es
tatted74920533ta_tted
tatter64024573ta_tter
tattie64817513tattie_
tattier74216243tattier
tatties74120343tatties
tattiest83415383tattiest
tattlers8369693tattlers
tauted75317113taut_ed
tauten64311893taut_en
tauter64318023taut_er
tautest72612443tautest
tautly9499503tautl_y
templet112712003templet
tercelet1049883tercelet
tercet83624913ter_cet
terret63425623ter_ret
tirled74714363tir_led
title54721073t_itle_
titled73815003t_itled
titles63719923t_itles
tittle63613323tittle_
tittles73413253tittles
toilet66228093t_oilet
tonlet62924703t_onlet
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
torte55431703tort_e_
torten65314353tort_en
tortes64826053tort_es
tortile7313193tortile_
townlet1049733townlet
trailed83415673trailed
trailer73015393trailer
trawled113411523trawled
trawler104011903trawler
trawley13317303trawley
trawlnet1146583trawlnet
tret46653533t_r__et
trevet94818913t_revet
trijet133916553t_rijet
triolet73219523triolet
triplet94319213triplet
trivet93721883t_rivet
turret63121853tur_ret
turtlers8258203turtlers
twattle1064273twattle_
twattled1273463twattled
twattles1154383twattles
valet84337873va__let
varlets10411573var_lets
wallet93327093wa_llet
warble113516603warble_
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
warsle93112923warsle_
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
warstle10328013warstle_
warstled12286123warstled
warstler11275933warstler
warstles11368803warstles
warted104223233wart_ed
wartier103413913wartier
wartiest113614643wartiest
wartless11279923wartless
wattle94314213wattle_
wattled113610503wattled
wattles103814073wattles
wavelet13310943wavelet

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 Filter1786911340270.216827273.1
2DLD Change Limit1340273537.94016880.0
3Display Results3533530.1232869.9
 (SQL Overall)1786913538.27921583.6
 
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.