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 “portliness” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
portliness124683(None) 
costliness1245992costliness
courtliness1343902courtliness
lordliness1144882lordliness
porkiness15249192por_kiness
portless10310642portl__ess
portliest11310182portli_est
portlinesses1446992portlinesses
potlines10714212po_tline_s
pottiness1179702po_ttiness
sportiness1278232sport_iness
worthiness1645912worthiness
artiness81615403_art_iness
artsiness937653_artsiness
burliness1137833bur_liness
comeliness1446993comeliness
corkiness152810443cor_kiness
corniness112611183cor_niness
curliness1138553cur_liness
dirtiness1039473dirt_iness
dorkiness14248053dor_kiness
dottiness1058043do_ttiness
earliness939693ear_liness
earthiness1377243earthiness
earthliness14144143earthliness
forkiness16268703for_kiness
frothiness1645723frothiness
ghostliness1542563ghostliness
godliness1136593go_dliness
goriness9310753gor__iness
goutiness1038763gout_iness
growliness1494073growliness
holiness112512503ho__liness
homeliness1545763homeliness
horniness12309143hor_niness
horsiness12259473hor_siness
hotlines11811643ho_tline_s
jolliness1636213jo_lliness
jowliness1934853jo_wliness
loftiness1236573loft_iness
loneliness1046083loneliness
loveliness1345303loveliness
lowliness1236403lo_wliness
oiliness8311563_o_iliness
outliners9228363_outliners
outlines82418093_outline_s
paltriness1244993paltriness
pastiness112312353past_iness
perkiness15209163per_kiness
pertness10310093pert__ness
pettiness1178703p_ettiness
pithiness1437563p_ithiness
plotlines1146823plotline_s
poetless1038723poetl__ess
pokiness14219863po__kiness
porousness1248443porousness
porteress1137933port_eress
portioners1257413portioners
portionless1344023portionless
portlier1038373portli_e_r
portress1038323port__ress
potline91015233po_tline__
poutines102415103pout_ine_s
pralines102217723p_raline_s
prettiness1257393prettiness
prolines102619693p_roline_s
prosiness11311683p_rosiness
purlines103514053pur_line_s
pursiness1138453pur_siness
rootiness979063root_iness
sootiness999833soot_iness
sorriness939583sor_riness
spottiness1285763spo_ttiness
surliness939943sur_liness
tartiness92112053tart_iness
trotlines939103trotline_s
unruliness1044633unruliness
wobbliness1742903wobbliness
wooliness12147693wo_oliness
woolliness1343563woolliness
wordiness13138633wor_diness
worldliness1542493worldliness
worminess14127613wor_miness

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 Filter1786911406030.1401276364.3
2DLD Change Limit140603838.12317309.2
3Display Results83830.0461804.3
 (SQL Overall)178691838.30921505.7
 
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.