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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
portionless134402(None) 
motionless1243482mo_tionless
portioners1257412portion_ers
actionless1244153_actionless
captionless1552503captionless
emotionless1352853emotionless
horizonless2391203horizonless
passionless1352873passionless
pensionless1353173pensionless
porkiness15249193porki_n_ess
portholes14410373portho_le_s
portioned1248333portion_e_d
portioner1158683portion_e_r
portions10514413portion___s
portless10310643port___less
portliness1246833portlin_ess
pottiness1179703potti_n_ess
sportiness1278233sporti_n_ess
ambitionless1661664ambitionless
artiness81615404_arti_n_ess
boonless10328354bo___onless
bottomless1442054bo_ttomless
brainless1136404_brai_nless
buttonless1242964_buttonless
carbonless1444084car_bonless
cohesionless1752014cohesionless
cordialness1444774cordialness
corkiness152810444corki_n_ess
corniness112611184corni_n_ess
cortisones1267054cortison_e_s
curtainless1351934curtainless
cushionless1651474cushionless
directionless1661934directionless
dirtiness1039474dirti_n_ess
doctorless1342584doct_orless
dorkiness14248054dorki_n_ess
dottiness1058044dotti_n_ess
foreignness1553014foreignness
forkiness16268704forki_n_ess
frictionless1752554frictionless
functionless1752414functionless
goriness9310754gor_i_n_ess
goutiness1038764gouti_n_ess
grainless1035894_grai_nless
horniness12309144horni_n_ess
hornless1137364hor___nless
horridness1443844horridn_ess
horsiness12259474horsi_n_ess
loftiness1236574lofti_n_ess
moonless10278044mo___onless
morbidness1573264morbidn_ess
mortarless1243104mort_arless
motioners1146574mo_tion_ers
motionlessly1751544mo_tionlessly
motiveless1542964mo_tiveless
motorless1145724mo_t_orless
optionees1144344_option_ees
orioles7412994_or_io_le_s
ostioles839274_ostio_le_s
painless10108344p__ai_nless
particles1339804parti_cle_s
partnerless1351874partnerless
pastiness112312354pasti_n_ess
patroness1137484p_atron_ess
patternless1342284patternless
perkiness15209164perki_n_ess
perniones1148594pernion_e_s
pertness10310094pert__n_ess
petioles10311644p_etio_le_s
pettiness1178704petti_n_ess
pitiless10127334p_iti__less
poeticalness1653454poeticalness
poetless1038724poet___less
pointless1135704po__intless
pokiness14219864po_ki_n_ess
politeness1247984politen_ess
pontoniers1245324pont_oniers
porousness1248444porousn_ess
porringers1343744porri_ngers
portables1337874port_able_s
portances1349834port_ance_s
porteress1137934port__eress
portfolios1572194portfo_lios
porthole1349524portho_le__
porticoes1348254porti_coe_s
portieres1138214porti_ere_s
portion9615494portion____
portioning1347194portion_ing
portress1038324port___ress
postholes14410454postho_le_s
postponers1445274postpon_ers
postpones1348834postpon_e_s
potboilers1462684po_tboilers
potholes13312934po_tho_le_s
potions93417424po_tion___s
poutines102415104pouti_n_e_s
priceless1336884p_r_iceless
primness1276764p_r_imn_ess
princess12266804p_r_i_ncess
printless1137514p_r_intless
prioress1035394p_r_io_ress
profitless1542764profi_tless
prosiness11311684prosi_n_ess
pursiness1138454pursi_n_ess
pythoness1743734p_ython_ess
questionless2152004questionless
rainless8129704__rai_nless
reinless8139434__rei_nless
rootiness979064rooti_n_ess
sootiness999834sooti_n_ess
sordidness1244634sordidn_ess
sorriness939584sorri_n_ess
sportfulness1754784sportfulness
sportiveness1766984sportiveness
spottiness1285764spotti_n_ess
tartiness92112054tarti_n_ess
tensionless1152674tensionless
torridness1164094torridn_ess
vibrationless1861424vibrationless
visionless1342964_visionless
wordiness13138634wordi_n_ess
worminess14127614wormi_n_ess
worthiness1645914worthin_ess
worthless1544924wort__hless

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 Filter1786911488190.406440125.6
2DLD Change Limit1488191249.07616397.0
3Display Results1241240.0631968.3
 (SQL Overall)1786911249.54518720.9
 
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.