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

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

88 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
partnerless135188(None) 
fatherless1644213fa_therless
mannerless1243523ma_nnerless
paneless102611773pa__ne_less
paperless1345833pa__perless
parentless1244463paren_tless
parterres1148083part_erre_s
partnered1244493partner_e_d
partners102711143partner___s
patternless1342283pa_tternless
porteress1137933port_er_ess
waterless1238013wa_t_erless
angerless1045024_a_ngerless
apartness1146054apartn___ess
apartnesses1346824apartnesse_s
armorless1143484_ar_morless
arteries8321514_art_erie_s
artless73712514_art___less
barterers11269644bart_er_ers
brineless1136264_brine_less
butterless1244194_butterless
careless102813634car__e_less
cateress102311614ca_t_er_ess
centerless1245004cent_erless
cotterless1244034_cotterless
craterlets1243504crat_erlets
dateless9259964da_t_e_less
dinnerless1152714_dinnerless
driverless1452704_driverless
featherless1743914featherless
gateless9279954ga_t_e_less
grateless10277584grat_e_less
hammerless1742374ha_mmerless
harborless1542664har_borless
linerless936334__linerless
lusterless1043694lust_erless
maneless102812344ma__ne_less
mateless102711294ma_t_e_less
mortarless1243104mort_arless
motherless1544094_motherless
natheless1244964na_the_less
orderless1044314_or_derless
painless10108364pa_in__less
painterliness1572434painterliness
palterers11249544palt_er_ers
pantdress1243364pant_dr_ess
pardners11269204pardner___s
parterre1037014part_erre__
particles1339814part_icle_s
partiers103514254partier___s
partlets102811524part___lets
partner92811394partner____
partnering1345554partner_ing
partnership1853724partnership
partnerships1953524partnerships
partyers13277764partyer___s
pastless102411204past___less
pastness102510504pastn___ess
pastnesses12910514pastnesse_s
pathless13138044pa_t__hless
patness92912284pa_tn___ess
patnesses111611794pa_tnesse_s
patterers112410134pa_tter_ers
peartness1137774peartn___ess
peartnesses1338744peartnesse_s
peerless1037514p___eerless
pertness10310094pertn___ess
pertnesses12310314pertnesse_s
portieres1138224portier_e_s
portionless1344044portionless
portless10310644port___less
portress1038324port__r_ess
powderless1642594p_owderless
powerless1444294p__owerless
prebless1236824p_r__ebless
priceless1336894p_rice_less
printless1137524p_rin_tless
proneness11310454p_rone_ness
properness1445924p_roperness
prunelles1145074p_runelle_s
riderless1044904__riderless
riverless1244944__riverless
shutterless1452134shutterless
tartness82210134tartn___ess
tartnesses101110714tartnesse_s
tasteless935674tast_e_less
virtueless1341934virtue_less
wartless11279924wart___less

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.423422437.4
2DLD Change Limit148819889.18616200.6
3Display Results88880.0461913.0
 (SQL Overall)178691889.65518507.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.