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

264 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
curtness103726(None) 
cureless10319702cureless
curliness1138552curliness
curtest9713962curt_est
curtesy1265832curt_esy
curtnesses1238362curtnesses
curtseys1342742curtseys
cuteness1039672cuteness
hurtless11307782hurtless
justness1535322justness
pertness10310092pertness
pureness101110182pureness
sureness8912902sureness
tartness82210132tartness
acuteness1145863acuteness
adultness1043973adultness
airiness8412213airiness
alertness946053alertness
apartness1146053apartness
aptness9268573_aptness
artiness81615403_artiness
artless73712513_artless
bareness10912813bareness
baroness101210063baroness
bluntness1144343bluntness
burgess10409343bur_gess
burliness1137833burliness
burners94115673bur_ners
burnets93813263bur_nets
burthens1335383burthens
business102110683business
bustiness111810463bustiness
busyness13264803busyness
buttress1035883buttress
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
careless102813633careless
caress85720263car__ess
carless95118493car_less
carnets93918403car_nets
carneys124310543car_neys
cartels94618123cart_els
carters95327243cart_ers
cartes86239473cart_e_s
cattiness112310633cattiness
centners1057243centners
certes84623083cert_e_s
chariness14310063chariness
chartless1435703chartless
chicness1535593chicness
churners13316883chur_ners
chutnees1343963chutnees
chutneys1642323chutneys
coatless1039693coatless
coldness1137953coldness
coolness1037743coolness
cordless11299963cordless
coreless103013833coreless
corkiness152810443corkiness
corneas94716993cor_neas
cornels94716663cor_nels
corners94723313cor_ners
cornets94820573cor_nets
corniness112611183corniness
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
cosiness103214283cosiness
costless10310003costless
countess103710043count_ess
countless1146373countless
courters103015363court_ers
courtesy1364973court_esy
courtiers1146683courtiers
courtliness1343903courtliness
covertness1545503covertness
coyness1277323c_oyness
coziness19319823coziness
cranes84330753c_rane_s
crenels93711013c_renels
cress75022833c_r__ess
crones84729243c_rone_s
crudeness1245753crudeness
cruelness1145053cruelness
crustiness1237263crustiness
crustless1155393crustless
cuffless1634283cuffless
cultuses1037753cultuses
cunners93913463cu_nners
curares94916853curare_s
curates95323823curate_s
curbers115514373cur_bers
curches143512743curche_s
curdiest112511393curdiest
curdlers11368493curdlers
curdles103814573curdle_s
curers84923183cur__ers
cures75645433cur__e_s
curets84922343cur__ets
curettes1039313curette_s
curfews15294913cur_fews
curies84934023cur_ie_s
curites93919863curite_s
curlers94218063cur_lers
curlews12387393cur_lews
curliest102713113curliest
curns74924273cur_n__s
currentness1352823currentness
currents1038373currents
curriers103410753curriers
curries93723163currie_s
cursedness1344463cursedness
cursers94317153cur_sers
curses85328273cur_se_s
curtails10318243curtails
curtainless1351933curtainless
curtains10259703curtains
curtals93111623curt_als
curter85320073curt_e_r
curtesies1147523curt_esies
curtsey1255013curtse_y
curtsies1038733curtsies
curtsy1156643curt__sy
curves114619283cur_ve_s
curvets12399913cur_vets
curviest13309673curviest
cushiness14197183cushiness
cutes79438313cu_t_e_s
cutest85820143cu_t_est
cutesy114810733cu_t_esy
cuteys11569973cu_t_eys
cuties84927363cu_tie_s
cutises94414913cu_tises
cutlass938013cu_tlass
cutlers94216993cu_tlers
cutlets94113653cu_tlets
cutters94218953cu_tters
cutties93118843cuttie_s
cuttles93613923cuttle_s
daftness1235533daftness
darkness13247343darkness
deftness1236303deftness
direness9311303direness
dirtiness1039463dirtiness
dourness947683dour_ness
dryness11114783_dryness
ductless11196313ductless
dueness82310123du_eness
dullness934873dullness
dulness8307983du_lness
dumbness1334613dumbness
dunness8298983du_nness
duress74712063dur__ess
dustiness102211023dustiness
dustless9328343dustless
eeriness8311873eeriness
farness102912203far_ness
fastness11238763fastness
fatness103311293_fatness
firmness1334743firmness
firstness1245003firstness
fitness10299393_fitness
flatness1138153flatness
fortress1136753fortress
fullness1135443fullness
fulness10248963fu_lness
furanes103214863furane_s
furless103210143fur_less
furriness12287593furriness
furthers1436493furthers
furthest1496863furthest
fustiness121910243fustiness
gastness9278473gastness
gauntness1044203gauntness
goriness9310753goriness
gurnets84010793gur_nets
gurneys11406463gur_neys
gustiness10189893gustiness
gustless9287683gustless
gutless82610713gu_tless
hardness122411083hardness
harness102413933har_ness
hotness1038603_hotness
hugeness1237373hugeness
huntress1144833huntress
hurters103413633hurt_ers
hurtles103913753hurtle_s
inertness947973inertness
juryless1832983juryless
kurtoses12105623kurtoses
lornness836493lornness
lostness837683lostness
luridness1045193luridness
lushness1136233lushness
lustiness92010453lustiness
meetness1036653meetness
miriness10310463miriness
mootness1036753mootness
moreness10911573moreness
muchness1534073muchness
murines93718223murine_s
murkiness15206283murkiness
murthers1336543murthers
mustiness112211653mustiness
muteness1039013muteness
neatness839153neatness
nudeness936733nudeness
numbness1234413numbness
nuttiness9207563nuttiness
overtness1238223overtness
partners102711133partners
pastness102510503pastness
patness92912283_patness
peartness1137773peartness
portless10310643portless
portress1038313portress
puniness101610273puniness
purines94420763purine_s
pursiness1138453pursiness
purtiest102414113purtiest
quietness1844753quietness
raptness1046733raptness
rareness81112853rareness
rudeness938083rudeness
runtiness92410393runtiness
rustiness92111923rustiness
rustless83510233rustless
ruttiness9258793ruttiness
saltness82610243saltness
scantness1135733scantness
scariness11310183scariness
scurviness1543283scurviness
secureness1245053secureness
shortness1236733shortness
smartness1136143smartness
softness1136433softness
soreness8914793soreness
sourness839543sour_ness
spryness1334003spryness
squatness1844943squatness
suchness1335763suchness
sultaness945613sultaness
surliness939943surliness
swartness1236113swartness
tartiness92112053tartiness
tautness8217183tautness
trueness838683trueness
turfless1135533turfless
turners73912893tur_ners
turtlers8258203turtlers
turtles72914343turtle_s
urines64724123_urine_s
vastness11257293vastness
wariness11313213wariness
warmness1337063warmness
wartless11279923wartless
wetness10277723_wetness
whatness1435093whatness
wiriness1138953wiriness
witness103010013_witness
wornness1136363wornness
wryness13113983_wryness

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.1701051123.5
2DLD Change Limit1461622649.06316127.3
3Display Results2642640.1102400.0
 (SQL Overall)1786912649.34319125.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.