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

129 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
unaware103803(None) 
unawake1445341unawake
unawares1137051unawares
aware86420022__aware
seaware1049632seaware
teaware1048142teaware
unawaked1635902unawaked
unawarded1444922unawarded
unawarely1543002unawarely
unswore1039052unswore
unwary1239822un_wary
anatase738943anatase
awake125014783__awake
award97118043__award
barware12610703barware
beware11313713_beware
caneware1347803caneware
chinaware1752973chinaware
clayware1643933clayware
ensnare767123ensnare
fanfare1336673fanfare
flatware1444883flatware
gnawable1435683gnawable
gnawer10386953gnawer_
gnawers11356393gnawers
gunwale1134733gun_wale
infare9313083in_fare
insnare748243insnare
inward10310333in_ward
knawe12397883knaw__e
manward1349093manward
nacre75715363_na_cre
nature6311263_nature
navar83912733_navar_
navars92810573_navars
nawab10810923_nawa_b
nawabs1185063_nawabs
onward1039053on_ward
outsware11168843outsware
reawake14457893reawake
redware1139363redware
runagate944293runagate
runaway1343683runawa_y
runaways1442853runaways
scalare93311833scalare
seaward1148183seaward
seawares1139333seawares
snare54429983sn__are
sunward1137653sun_ward
sware85828213__sware
teawares1148083teawares
tinware1038603tinware
uakari1046863u_akari
unabated11310133unabated
unable83819223una_ble
unagile838283unagile
unaired82916013una_ired
unakite1138743unakite
unalarmed1244633unalarmed
unalike11311533unalike
unamazed2035883unamazed
unarm7314453un__arm
unary8315993un__ary
unawed103914903unaw_ed
unbale83616403un_bale
unbar71913613un_bar_
unbars82113033un_bars
unbear889163unbear_
unbeared111611653unbeared
unbears998043unbears
unbrace111910483unbrace
unbrake13239123unbrake
uncage93014873un_cage
uncake122813523un_cake
uncase83817433un_case
uncharge1446313uncharge
unchary1537263unchary
unciae83215313uncia_e
uncrate9415953uncrate
undrape1049333undrape
unease63816643un_ease
unfeared121511013unfeared
unguard955093unguard
unheard1136943unheard
uniface1236953uniface
unitage838993unitage
unitard838003unitard
unitary1038613unitary
unlace82215173un_lace
unlade72714153un_lade
unlearn735953unlearn
unmade92911063un_made
unmake122811213un_make
unmitre936993unmitre
unpure82911533un_pure
unsafe9310693un_safe
unseared91113943unseared
unshared121510703unshared
unsharp1235543unsharp
unsmart939603unsmart
unsnarl7107153unsnarl
unstate71916213unstate
unsure62815413un_sure
unswathe1444603unswathe
unswayed15155713unswayed
unswear1035003unswear_
unswears1144023unswears
unsworn1046843unsworn
untame82513603un_tame
untoward1243193untoward
untwine1038623untwine
unwarier1136883un_warier
unwarmed1437303un_warmed
unwarned1238453un_warned
unwarped1436873un_warped
unwaxed18308393un_waxed
unweary1335843unweary
unweave1336363unweave
unwise9510803un_wise
unworn93411333un_worn
unwove12238883un_wove
unwrap11126323un_wrap
upstare9158683upstare
upward12147163u_pward
urare56322553u__rare
vanward1456943vanward
vaward13498723_vaward
ware76254723___ware
wetware1335793wetware

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271295.97022450.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.42227824.8
 
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.