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

344 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
tartness8221013(None) 
tartiness92112051tartiness
tautness8217181tautness
apartness1146052apartness
aptness9268572_aptness
artiness81615402_artiness
artless73712512_artless
bareness10912812bareness
baroness101210062baroness
curtness1037262curtness
daftness1235532daftness
darkness13247342darkness
farness102912202far_ness
fastness11238762fastness
fatness103311292fa_tness
gastness9278472gastness
hardness122411082hardness
harness102413932har_ness
partners102711132partners
pastness102510502pastness
patness92912282pa_tness
peartness1137772peartness
pertness10310092pertness
raptness1046732raptness
rareness81112852rareness
saltness82610242saltness
smartness1136142smartness
starkness1335962starkness
swartness1236112swartness
tacitness1134872tacitness
tactless10288462tactless
tallness837102tallness
tameness102411252tameness
tardiness10229912tardiness
tarriness9229242tarriness
tartest72517532tart_est
tartiest82718312tartiest
tartlets8289662tartlets
tartnesses101110712tartnesses
tastiness92311142tastiness
tattiness9239412tattiness
teariness9310632teariness
vastness11257292vastness
wariness11313212wariness
warmness1337062warmness
wartless11279922wartless
actress948533_actress
airiness8412213airiness
alertness946053alertness
archness1337513_archness
arenes64928393_arene_s
aridness939223_aridness
armless9369943_armless
artels66216233_art_els
artiest73121993_artiest
artsiness937653_artsiness
awareness1236343awareness
badness1039573ba_dness
baldness1137043baldness
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
barneys12569563bar_neys
baronets101410903baronets
bartends1136793bartends
barters94223033bart_ers
baseness10910943baseness
bassness1096743bassness
battiness11239843battiness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
careless102813633careless
caress85720263car__ess
carless95118493car_less
carnets93918403car_nets
carneys124310543car_neys
cartels94618123cart_els
carters95327243cart_ers
cartes86239473cart_e_s
cattiness112310633cattiness
chariness14310063chariness
chartless1435703chartless
dampness1336073dampness
dankness13256693dankness
darnels83710433dar_nels
darners83815773dar_ners
darters84017603dart_ers
dartles84014133dartle_s
dearness939973dear_ness
deftness1236303deftness
direness9311303direness
dirtiness1039463dirtiness
drabness1135803drabness
dryness11114783_dryness
dwarfness1642793dwarfness
earless74316063ear_less
earliness939693earliness
earners74016453ear_ners
earnest7318733ear_nest
earnests837853ear_nests
earthiness1377243earthiness
earwitness1342623earwitness
easiness8313043easiness
eeriness8311873eeriness
exactness1843623exactness
faintness1235833faintness
fairness1136563fairness
farthest1499863farthest
fartleks1533963fartleks
fatless103212203fa_tless
fattiness12239373fattiness
firmness1334743firmness
firstness1245003firstness
fitness10299393_fitness
flatness1138153flatness
fortress1136753fortress
gameness112810693gameness
gaminess112911053gaminess
garbless11388253garbless
garners83815983gar_ners
garnets84115403gar_nets
garters84218223gart_ers
gauntness1044203gauntness
gayness1136843ga_yness
glariness1038553glariness
goriness9310753goriness
grayness1235933grayness
hairiness1238013hairiness
haleness11312623haleness
halfness1435563halfness
haltless11308443haltless
hardiness132310353hardiness
harmless1337403harmless
harshness1545963harshness
hastiness122410883hastiness
hatless103813443ha_tless
haziness20248513haziness
heartiness1338033heartiness
heartless1236393heartless
hoariness1238823hoariness
hotness1038603_hotness
hurtless11307783hurtless
inaptness1144333inaptness
inertness947973inertness
intactness1244313intactness
irateness9310493irateness
justness1535323justness
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
largeness1038273largeness
largess8408913lar_gess
larkiness1338113larkiness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
lornness836493lornness
lostness837683lostness
madness10310073ma_dness
maleness10312313maleness
maltiness112910573maltiness
mariners103113863mariners
marines93928013marine_s
marquess19204953marquess
martens93714953mart_ens
martinets1138883martinets
martlets103310483martlets
mastless102610023mastless
matiness102114743matiness
matless93014043ma_tless
mattress1036533mattress
maziness19239543maziness
meetness1036653meetness
miriness10310463miriness
mootness1036753mootness
moreness10911573moreness
nastiness92310573nastiness
nattiness9239333nattiness
nearness838313near_ness
neatness839153neatness
oarless73913373oar_less
oratress834553oratress
overtness1238223overtness
packness1636933packness
paleness10312983paleness
pardners11269193pardners
partiers103514243partiers
parties93230863partie_s
partlets102811513partlets
partner92811393partne_r
partyers13277763partyers
pastiness112312353pastiness
pastless102411203pastless
patroness1137483patroness
portless10310643portless
portress1038313portress
pureness101110183pureness
raciness102413453raciness
rankness12267943rankness
rashness1138093rashness
rawness1038153ra_wness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
sarsnets836783sarsnets
scantness1135733scantness
scariness11310183scariness
sharpness1434933sharpness
shortness1236733shortness
softness1136433softness
soreness8914793soreness
spareness1139863spareness
spryness1334003spryness
staginess1038753staginess
staidness1037033staidness
staleness9310783staleness
starless81610843star_less
starters83714763start_ers
startlers9236733startlers
startles82111963startle_s
sternness946093sternness
stoutness945853stoutness
straitness1046283straitness
sureness8912903sureness
tackiness1557693tackiness
tackless14419483tackless
tacrines10310563tacrine_s
tailless8239083tailless
taintless935733taintless
talkiness1356913talkiness
tameless10259903tameless
tanginess10239283tanginess
tankless12267823tankless
tanners74018393ta_nners
tannest72617853ta_nnest
tapeless10218643tapeless
tarantas839193tarantas
tardies84225863tardie_s
tardiest93515243tardiest
tares57456563tar__e_s
targes74524593tar_ge_s
targets84314223tar_gets
tarnish101611873tar_nish
tarns56433953tar_n__s
tarres64723043tar_re_s
tarriers83411713tarriers
tarries73324263tarrie_s
tarriest83215003tarriest
tarsiers8298533tarsiers
tartanas8258893tartanas
tartans72615823tart_ans
tartars73313403tart_ars
tarted74923373tart_e_d
tarter64023563tart_e_r
tartier74123263tartie_r
tartinesses111011493tartinesses
tartish101512633tart_ish
tartlet72218483tartle_t
tarts57242023tart___s
tartufes1164153tartufes
tarweeds1244273tarweeds
tasteless935673tasteless
tasters74225643tast_ers
tastes64126423tast_e_s
tastiest83216633tastiest
taters64932193ta_t_ers
tates55444983ta_t_e_s
tatters74520483ta_tters
tatties74120343tattie_s
tattiest83415383tattiest
tattlers8369693tattlers
tattles73616283tattle_s
taunters8259263taunters
taurines8310543taurine_s
tautens7317843taut_ens
tautest72612443taut_est
tautnesses10118283tautnesses
tawdriness1482843tawdriness
tawneys13324773ta_wneys
tawniness1245123tawniness
taxless1436903ta_xless
tearless848703tear_less
tentless8229843tentless
termless1036233termless
ternes65422903ter_ne_s
terseness948403terseness
testiness9209753testiness
textless15245793textless
thinness11277153thinness
thrones105715843throne_s
tidiness938793tidiness
tightness1386603tightness
tininess8310633tininess
tintless8239863tintless
tiredness1036933tiredness
tireless82510263tireless
titaness836723titaness
tortes64826053tort_e_s
trainees82712063trainees
trainers83114633trainers
traitress944403traitress
tramless1037503tramless
trapnest10310923trapnest
trapnests1144433trapnests
tress55423163t_r__ess
trigness968403trigness
trimness1067563trimness
trines64132563t_rine_s
triteness9310363triteness
trones65629283t_rone_s
trueness838683trueness
turfless1135533turfless
turners73912893tur_ners
turtlers8258203turtlers
turtles72914343turtle_s
tweeness11246403tweeness
unaptness1154173unaptness
vainness1136063vainness
waeness102512783wa_eness
waitress1135223waitress
wanness102610683wa_nness
wardless12249303wardless
wardress12256163wardress
warless104015103war_less
warners103315563war_ners
wartiest113614643wartiest
wattless11268723wattless
waviness1437723waviness
waxiness1836723waxiness
weariness1238843weariness
wetness10277723_wetness
whatness1435093whatness
wiriness1138953wiriness
witness103010013_witness
wornness1136363wornness
wryness13113983_wryness
yarners104312203yar_ners
zaniness1738663zaniness

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.1701051123.5
2DLD Change Limit1461623447.39019778.3
3Display Results3443440.1402457.1
 (SQL Overall)1786913447.70023206.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.