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

152 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
unjammed203362(None) 
enjambed2042822enjambed
jammed183811502__jammed
unaimed102812492un_aimed
unarmed101811922un_armed
undamped1445332undamped
undimmed1434112undimmed
unharmed1438092unharmed
unjaded16279142unja_ded
unnamed102410272unna_med
untamed102913222unta_med
unwarmed1437302unwarmed
bammed133913243__bammed
clammed14369963_clammed
crammed143710123_crammed
dammed124214793__dammed
drammed13378073_drammed
encamped1535023encamped
flammed15377413_flammed
gammed124216163__gammed
hammed144116973__hammed
inarmed10268673in_armed
jambed184811403__jambed
jammer174014133__jammer
lammed113915623__lammed
logjammed2251763logjammed
named85223063_n_a_med
nimmed11368573_n_immed
pajamaed2042623pajamaed
rammed113117303__rammed
scammed14479543_scammed
scrammed1555003scrammed
shammed153911423_shammed
slammed123511103_slammed
spammed14348523_spammed
trammed123810713_trammed
unacted10312733un_acted
unadded10238523un_added
unaged83916423un_a_ged
unaided92414603un_aided
unaired82916013un_aired
unalarmed1244633unalarmed
unamazed2035883un_amazed
unamused1135793un_amused
unasked122010023un_asked
unawed103914903un_a_wed
unaxed144113093un_a_xed
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unba_led
unbanded123010563unbanded
unbanned11279113unbanned
unbarbed13217753unbarbed
unbarred11238703unbarred
unbased103513483unba_sed
unbasted112510073unbasted
unbated103317733unba_ted
unbathed1437223unbathed
unblamed1337193unblamed
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncanned11289963uncanned
uncapped1556693uncapped
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
unclaimed1435793unclaimed
unclamped1664503unclamped
uncombed1536323uncombed
undamaged1443423undamaged
undated93118463unda_ted
unearned9310063unearned
unfaded123111733unfa_ded
unfaked153211173unfa_ked
unfazed20299053unfa_zed
unfilmed1495803unfilmed
unformed14239573unformed
unframed1478243unframed
ungalled1078463ungalled
ungarbed12197063ungarbed
ungated92717213unga_ted
unhailed12219963unhailed
unhaired12238763unhaired
unhalved1556513unhalved
unhanded132910183unhanded
unhanged13258833unhanged
unhatted1238183unhatted
unhelmed1435993unhelmed
unjam1448723unja_m__
unjamming2143043unjamming
unjams1555703unja_m_s
unjoined16248443unjoined
unjudged1843453unjudged
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unmailed11229763unmailed
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmated103317023unma_ted
unmatted1138293unmatted
unnailed9229443unnailed
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unpa_ged
unpaired11208943unpaired
unparted11310823unparted
unpaved133410053unpa_ved
unprimed1337203unprimed
unraised91811883unraised
unraked122914013unra_ked
unranked1338563unranked
unrated82621553unra_ted
unrazed172511453unra_zed
unrhymed1742853unrhymed
unrimed102211633un_rimed
unsalted9510923unsalted
unsampled1444443unsampled
unsated83419933unsa_ted
unsaved113312193unsa_ved
unsawed112911503unsa_wed
unseamed111210663unseamed
unshamed14148053unshamed
unstamped1454603unstamped
unstemmed1443303unstemmed
untacked15239923untacked
untagged1135973untagged
untame82513603unta_me_
untanned9279963untanned
untapped1376613untapped
untasted92011573untasted
untaxed152710583unta_xed
untimed102713373un_timed
untrimmed1443563untrimmed
unvalued1266313unvalued
unvaried1239683unvaried
unwalled1288653unwalled
unwanted12249603unwanted
unwarned1238453unwarned
unwarped1436873unwarped
unwashed15288483unwashed
unwasted12259783unwasted
unwaxed18308393unwa_xed
whammed18345133_whammed

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621527.67019056.3
3Display Results1521520.0632412.7
 (SQL Overall)1786911528.13921954.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.