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

362 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
tartily10351157(None) 
artily92814711_artily
tardily11269581tardily
tartly96014021tart_ly
tastily103311641tastily
tattily10409991tattily
cattily123210852cattily
dirtily1138582dirtily
earthily1445612earthily
earthly13387382earthly
fattily13379462fattily
hardily143310272hardily
hastily133010662hastily
heartily1436562heartily
nastily103011032nastily
nattily103610322nattily
partly116315472part_ly
saltily10310542saltily
tacitly1236222tacitly
tackily1637502tackily
tactile9310612tactile
tantivy1335562tantivy
tartier74123262tartier
tarting84222652tarting
tartish101512632tartish
tarty86328182tart__y
tautly9499502taut_ly
tawnily1335442tawnily
tearily10311152tear_ily
testily102910802testily
tortile7313192tortile
tuftily1335572tuftily
warily122915092war_ily
aerily93017013_aerily
airily93014823_airily
anticly12410053_anticly
aptly105111813_apt_ly
archly1437353_archly
argil65116883_argil_
argils75213623_argils
aridly105513703_aridly
aril45843023_ar_il_
arils58732203_ar_ils
artal55525473_artal_
artel56122743_artel_
artels66216233_artels
artery9911453_artery
article9310923_article
artier63419733_artier
artist64125543_artist
artsy86012963_art_sy
arty77531313_art__y
atilt54828473_a_tilt
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
barely114716793bar_ely
barfly14339653bar_fly
bastile9313913bastile
bawdily1635803bawdily
burlily1237713burlily
cagily12411563ca_gily
campily1638273campily
cannily1239263cannily
carnify1555883carnify
cartel85022533cartel_
cartels94618123cartels
carting104228283carting
certify1546243certify
charily15310283char_ily
chattily1634603chattily
cornily12410853cornily
craftily1644783craftily
crazily2136923crazily
curlily1238383curlily
curtly1149283curt_ly
daffily1735133daffily
daftly1335443daft_ly
daily95922333da__ily
daintily1245523daintily
dandily12279633dandily
darkly145411073dar_kly
darting94020663darting
dartingly1436943dartingly
dartle73714833dart_le
daylily1434983daylily
dottily1147283dottily
draftily1534413draftily
drily95816523_dr_ily
dustily113211523dustily
early85324123ear__ly
earthy12399943eart_hy
easily9313023ea_sily
eerily92913563eer_ily
emptily1445813emptily
family143311703fa_mily
fancily1538253fancily
farting114120753farting
fatly115716803fa_t_ly
faultily1474523faultily
fertile10311733fertile
fortify1636523fortify
furrily1337613furrily
fustily133111373fustily
gaily95020973ga__ily
gamily123712183ga_mily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
gorily10612503gor_ily
goutily1137933goutily
gratify1436113gratify
gustily113010903gustily
hammily1736063hammily
handily143610873handily
happily1745763happily
hardly135112833har_dly
harshly1636273harshly
hartal9415473hartal_
hartals10313023hartals
hazily2179063ha_zily
heftily1635763heftily
hoarily1338973hoar_ily
hornily1338283hornily
horsily1338843horsily
irately1047683irately
jauntily1834173jauntily
jazzily2533373jazzily
jerkily2134623jerkily
joltily1746323joltily
karting123716063karting
lacily11612763la_cily
laithly1335653laithly
lankily1437123lankily
largely1136703largely
lastly93310873last_ly
lately93413843la_tely
lazily1859713la_zily
loftily1336353loftily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
marbly134111933mar_bly
marly106925613mar__ly
martial92415413martial
martially1448183martially
martian93514683martian
martin84122523marti_n
marting103325013marting
martini93613873martini
martins93322063martins
martyrly1642353martyrly
martyry1533373martyry
mazily20610393ma_zily
meatily12311093meatily
merrily1238633merrily
mirkily16266403mirkily
mistily122612343mistily
mortify1536223mortify
murkily16287113murkily
mustily123613633mustily
nargile847653nargile
nautili746113nautili
nervily1336863nervily
niftily1335753niftily
nuttily10308633nuttily
paltrily1345413paltrily
pantile93918483pantile
parity114719873par_ity
partial92616263partial
partially1449033partially
partials101911953partials
partible1238063partible
particle1239533particle
partied103516553partied
partier93520713partier
parties93230863parties
parting103527383parting
partita9310863partita
partite9317133partite
partway1535923partway
party106630613part__y
pastil85018323pastil_
pastils94416173pastils
patly105020583pa_t_ly
pawkily1934203pawkily
peartly1267453peart_ly
perkily1637813perkily
pertly115312553pert_ly
pettily1238173pettily
portly114713403port_ly
pursily1238213pursily
quartile1747043quartile
racily11715173ra_cily
rainily10310433rainily
ramtil8311023ramtil_
ramtils938413ramtils
raptly11338913rapt_ly
rarely93513653rar_ely
rarify123210063rar_ify
rarity93615493rar_ity
ratify122610043ra_tify
rattly94111543ra_ttly
roily86121113__roily
rustily103112993rustily
ruttily10338613ruttily
sappily1437163sappily
sassily1038723sassily
satiny93817983sa_tiny
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
scarily12311703scar_ily
smarmily1543523smarmily
smartly12497433smart_ly
snarkily1534583snarkily
sootily101810523sootily
sorrily1039833sorrily
sparkily1735023sparkily
sportily1337733sportily
stagily1139053sta_gily
stalkily1534823stalkily
starchily1745013starchily
starkly14277033star_kly
starting93116173starting
startle72511123start_le
startsy10536703start_sy
stately10310223sta_tely
stormily1345243stormily
straitly1136563straitly
stratify1445703stratify
sturdily1245083sturdily
surlily10310003surlily
swarthily1842583swarthily
tackify1934493tackify
tactic10612753tacti_c
tactics1149323tactics
tactilely1443433tactilely
tactility1446833tactility
taction93213023taction
tahsil936343tahsil_
tahsils1035053tahsils
tail45443653ta__il_
tails55634193ta__ils
tally84526863ta__lly
tamely113711953ta_mely
tangibly1444673tangibly
tangly104413913ta_ngly
tardier859719993tardier
tardies84225863tardies
tardive1136893tardive
tardy94720463tar__dy
tariff12711363tar_iff
taring73932283tar_ing
tarnal63716503tarnal_
tarnally1138273tarnally
tarnish101611873tarnish
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarring83318303tarring
tarry85422513tar__ry
tarsal63315273tarsal_
tarsals72512603tarsals
tarsi55222173tarsi__
tarsia65514273tarsi_a
tarsias74013373tarsias
tarsier74119253tarsier
tart47566183tart___
tartan64217513tart_an
tartana73010193tartana
tartans72615823tartans
tartar63214753tart_ar
tartare73012683tartare
tartars73313403tartars
tarted74923373tart_ed
tarter64023563tart_er
tartest72517533tartest
tartiest82718313tartiest
tartlet72218483tartlet
tarts57242023tart__s
tartufe1064673tartufe
tastier711817093tastier
tasting84624213tasting
tasty84820313tast__y
tattie64817513tatti_e
tattier74216243tattier
tatties74120343tatties
tatting84019523tatting
tattle64115653ta_ttle
tatty84720183ta_t_ty
tauting83316383tauting
tawdrily1542733tawdrily
taxably1936043taxably
techily1537123techily
tenthly1335743tenthly
termly1138433ter_mly
terribly1344923terribly
terrify1336353terrify
tersely1038113tersely
tertial7313863tertial
tertials8510073tertials
tertian7511193tertian
tertiary1145433tertiary
testify13246943testify
textile1437223textile
thirstily1542693thirstily
thornily1444163thornily
thriftily1842003thriftily
thrill94910593thr_ill
throatily1543703throatily
thwartly1742703thwart_ly
tidily102811393t_idily
tinily94014433t_inily
tinnily1047363tinnily
tipsily1236043tipsily
tiredly1136803tiredly
toothily1445523toothily
torpidly1483653torpidly
torridly1284473torridly
torrify1335013torrify
tortilla845893tortilla
tractile10311073tractile
trail55126773t_rail_
trails64622513t_rails
trashily1437323trashily
trebly1138973t_rebly
trigly103810943t_rigly
trilby1144973t_r_ilby
trill55122933t_r_ill
trimly114410893t_rimly
triply114211023t_riply
tritely1039003tritely
trolly94012363t_rolly
truly84111553t_r_uly
trustily11257103trustily
turbidly1443683turbidly
turgidly1343353turgidly
turtle63213573turt_le
varsity1356673varsity
vastity1336203vastity
vastly12508723vast_ly
verily122616053ver_ily
wackily1936053wackily
warmly14228063war_mly
wartier103413913wartier
wartime1237743wartime
warty119323823wart__y
waspily1535513waspily
wavily15219483wa_vily
waxily19218413wa_xily
wearily1338783wear_ily
wirily123310783wir_ily
wittily1336173wittily
wordily1437853wordily
worthily1745253worthily
wrathily1744773wrathily
yarely122810303yar_ely
yeastily1444573yeastily
zanily18310183za_nily
zestily19167563zestily

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273626.89319443.9
3Display Results3623620.1232943.1
 (SQL Overall)1786913627.43624030.5
 
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.