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

128 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
unamused113579(None) 
unabused1135621unabused
amused94412512__amused
unamassed1244242unamassed
unamazed2035882unamazed
unaroused1046532unaroused
unbemused1442562unbemused
uncaused1138452uncaused
unfused11319512un_fused
unhoused1238152unhoused
unused72012882un__used
abused95614273__abused
amuse75920833__amuse_
amuser84712623__amuser
amuses85117943__amuses
analysed12166913analysed
animuses1037983animuses
bemused1236713_bemused
campused1535253_campused
caused95117043_ca_used
enameled1136373enameled
enamored1147033enamored
enamoured1243933enamoured
enthused1245083enthused
incused102911173in_cused
infused11329253in_fused
mandamused1652093mandamused
mused85524583___mused
named85223063_nam__ed
natured838963_natured
nausea637313_na_usea
nimbused1343013_nimbused
paused95114963_pa_used
shamuses1336153shamuses
snafued1134933snafu_ed
unabashed1544103unabashed
unabated11310133unabated
unabjured1942803unabjured
unacted10312733una_cted
unadded10238523una_dded
unadjusted1942493unadjusted
unadmired1343863unadmired
unadvised1443283unadvised
unaged83916423una__ged
unagreed1036823unagreed
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unallied938393unallied
unamended1344853unamended
unamusing1254203unamusing
unaneled939793unaneled
unarched14128553unarched
unargued1035583unargued
unarmed101811923una_rmed
unarmored1244873unarmored
unasked122010023una_sked
unassured1084353unassured
unatoned939423unatoned
unattuned1043343unattuned
unaus53216573una_us__
unavowed1534783unavowed
unawaked1635903unawaked
unawed103914903una__wed
unaxed144113093una__xed
unbased103513483un_based
unbiased1147153unbiased
unbruised1244763unbruised
unbrushed1544433unbrushed
unbusted11258773un_busted
uncased104216953un_cased
unclosed111010513unclosed
uncrushed1545033uncrushed
uncured10513233un_cured
uncursed1148973uncursed
undamaged1443423undamaged
undamped1445333undam_ped
underused1139333underused
unerased9312783unerased
unexcused1942483unexcused
unfluted1237173unfluted
unfocused1553403unfocused
unglued937303unglu_ed
unhorsed1238833unhorsed
unhouse1038923unhouse_
unhouses1138703unhouses
unhusked1634603un_husked
unimbued1343073unimbued
unissued934683unissued
unjammed2033623unjam_med
unkissed1334893unkissed
unleased9310713unleased
unloosed9117523unloosed
unmailed11229763unmailed
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmated103317023un_mated
unmatted1138293unmatted
unmatured1245703unmatured
unmeshed1437003un_meshed
unmewed13258173un_mewed
unmined102612953un_mined
unmixed17228213un_mixed
unmoved13248903un_moved
unnamed102410273unnam__ed
unpoised1139183unpoised
unposed10711903un_posed
unpruned1136863unpruned
unraised91811883unraised
unrinsed938383unrinsed
unruled8311373un_ruled
unrushed12247573un_rushed
unrusted92310353un_rusted
unsampled1444443unsampled
unsmoked1536013unsmoked
unsoured9310063unsoured
untamed102913223untam__ed
untrussed1045543untrussed
untuned82010823un_tuned
unvalued1266313unvalu_ed
unversed122310433unversed
uproused1135843uproused
uraeuses835383uraeuses
vamosed1335923_vamosed
wamuses1237023_wamuses

Search took 8 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.466383457.1
2DLD Change Limit1461621287.33019940.2
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.84222786.4
 
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.