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

131 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
shortness123673(None) 
hotness1038612_ho_tness
sharpness1434932sharpness
shirtless12266412shirtless
shoreless1236632shoreless
shorteners1345082shorteners
shortens11288992short_ens
shortest11310782short_est
shorties11414582shortie_s
shortnesses1446792shortnesses
showiness1576072showiness
smartness1136142smartness
softness1136432s_oftness
soreness8914792s_oreness
sportiness1278232sportiness
stoutness945862stoutness
swartness1236112swartness
alertness946053alertness
apartness1146053apartness
chariness14310063chariness
chartless1435703chartless
chorines132917253chorine_s
chortens13308793chort_ens
chortlers14305663chortlers
chortles133611323chortle_s
curtness1037263_curtness
fortress1136753_fortress
goriness9310753_goriness
hardness122411083_hardness
harness102413933_har_ness
hoariness1238823_hoariness
hokiness152510183_hokiness
holiness112512503_holiness
hominess132712453_hominess
hornets104113553_hor_nets
horniness12309143_horniness
hornless1137363_hornless
horsiness12259473_horsiness
hostess103210243_host_ess
hurtless11307783_hurtless
inertness947973inertness
lornness836493_lornness
lostness837683_lostness
mootness1036753_mootness
moreness10911573_moreness
overtness1238223overtness
peartness1137773peartness
pertness10310093_pertness
phoniness1436303phoniness
poorness1036363poor_ness
portless10310643_portless
portress1038323_portress
saltness82610243s_altness
savoriness1354933savoriness
scantness1135733scantness
scariness11310183scariness
scoreless1155603scoreless
scorners10228493scor_ners
shadiness1337463shadiness
shakiness1637083shakiness
sheerness1236273sheerness
sheetless1235823sheetless
shiftiness1644793shiftiness
shiftless15265303shiftless
shininess1237333shininess
shirtdress1441813shirtdress
shirtiest1239323shirtiest
shitless11249243sh_itless
shoddiness1543563shoddiness
shoeless1137803sho_eless
shoetrees1244353shoetrees
shooters112811583shoot_ers
shorans102812413shoran__s
shores94830413shor__e_s
shorings12269483shorin_gs
shortages1336513shortages
shortcuts1442513shortcuts
shorted113614403short_e_d
shorten103511413short_e_n
shortened1345663shortened
shortener1245773shortener
shorter103515503short_e_r
shorthead1644473shorthead
shortheads1743813shortheads
shortias1148093short_ias
shortie10411343shortie__
shortish1437423short_ish
shortlist1246683shortlist
shortlists1344083shortlists
shorts95321743short___s
shotes95321913sho_t_e_s
shouters113510623shout_ers
shrines104618693sh_rine_s
shyness1344993sh__yness
skirtless13254423skirtless
slowness1135013slo_wness
smokiness1535543smokiness
smoothness1543043smoothness
snootiness1085833snootiness
snorters83410583snort_ers
snottiness1055593snottiness
snowiness1296243snowiness
soleness8814263s_oleness
sootiness999833sootiness
sorners73416873s_or_ners
sorriness939583sorriness
sorters74221133s_ort_ers
sorties74126403s_ortie_s
sourness839543s_ourness
spareness1139863spareness
sporters103714063sport_ers
sportiest111711023sportiest
spotless1037043spo_tless
spottiness1285763spottiness
spoutless1134243spoutless
spryness1334003s_pryness
squatness1844943squatness
starkness1335963starkness
sternness946093sternness
stoniness938343stoniness
storminess1245213storminess
sureness8912903s_ureness
sweetness1245683sweetness
swiftness1543653swiftness
tartness82210133_tartness
thorniness13264343thorniness
thornless1243633thornless
whatness1435093wh_atness
wholeness1545373wholeness
whortles14306743whortle_s
wornness1136363_wornness

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 Filter1786911486410.186960704.3
2DLD Change Limit1486411317.93618730.0
3Display Results1311310.0632079.4
 (SQL Overall)1786911318.18521831.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.