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

126 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
unabused113562(None) 
unamused1135791unamused
abused95614272__abused
unabashed1544102unabashed
unabated11310132unabated
unabjured1942802unabjured
unaroused1046522unaroused
unbased103513482un_based
unbusted11258772un_busted
uncaused1138452uncaused
unfused11319512un_fused
unhoused1238152unhoused
unused72012882un__used
abased96514993__abased
abuse77119563__abuse_
abuser85413683__abuser
abuses85119103__abuses
amused94412513__amused
anabases1038083anabases
analysed12166913analysed
bused85624493___bused
caused95117043_ca_used
disabused1344903disabused
enabled102510633enab_led
enthused1245083enthused
incused102911173in_cused
infused11329253in_fused
nabbed115113613_nab_bed
natured838963_natured
nausea637313_na_usea
nimbused1343013nimbused
paused95114963_pa_used
snafued1134933snafu_ed
tabued94310403_tabu_ed
unabetted1244993unabetted
unable83819223unab_le_
unaborted1245733unaborted
unabraded1344893unabraded
unabusive1452353unabusive
unacted10312733una_cted
unadded10238523una_dded
unadjusted1942493unadjusted
unadvised1443283unadvised
unaged83916423una__ged
unagreed1036823unagreed
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unallied938393unallied
unamassed1244243unamassed
unamazed2035883unamazed
unaneled939793unaneled
unarched14128553unarched
unargued1035583unargued
unarmed101811923una_rmed
unasked122010023una_sked
unassured1084353unassured
unatoned939423unatoned
unattuned1043343unattuned
unaus53216573una_us__
unavowed1534783unavowed
unawaked1635903unawaked
unawed103914903una__wed
unaxed144113093una__xed
unbacked17268733unbacked
unbaked143312893un_baked
unbaled103315963un_baled
unbanded123010563unbanded
unbanned11279113unbanned
unbarbed13217753unbarbed
unbarred11238703unbarred
unbasted112510073unbasted
unbated103317733un_bated
unbathed1437223unbathed
unbemused1442563unbemused
unbiased1147153unbiased
unboned103014223un_boned
unbowed132610243un_bowed
unboxed17249573un_boxed
unbred92613303un_b_red
unbruised1244763unbruised
unbrushed1544433unbrushed
unbuild1035723un_build
unburied11208513un_buried
unburned11227413un_burned
unbusy1135213un_bus_y
uncased104216953un_cased
unclosed111010503unclosed
uncrushed1545023uncrushed
uncured10513233un_cured
uncursed1148973uncursed
underused1139333underused
undubbed1443523undubbed
unerased9312773unerased
unexcused1942483unexcused
unfluted1237173unfluted
unfocused1553403unfocused
unglued937303unglu_ed
unhorsed1238833unhorsed
unhouse1038923unhouse_
unhouses1138703unhouses
unhusked1634603un_husked
unimbued1343073unimbu_ed
unissued934683unissued
unkissed1334893unkissed
unlabeled1244363unlabeled
unlabored1243813unlabored
unleased9310713unleased
unloosed9117523unloosed
unmatured1245703unmatured
unpoised1139183unpoised
unposed10711903un_posed
unpruned1136863unpruned
unraised91811883unraised
unrebuked1652673unrebuked
unrinsed938383unrinsed
unruled8311373un_ruled
unrushed12247573un_rushed
unrusted92310353un_rusted
unsoured9310063unsoured
untrussed1045543untrussed
untuned82010823un_tuned
unvalued1266313unvalu_ed
unversed122310433unversed
uproused1135833uproused
uraeuses835383uraeuses

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.436409841.7
2DLD Change Limit1461621267.37619815.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.85822740.0
 
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.