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

125 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
unswear103500(None) 
unswears1144021unswears
answer936892answe_r
menswear1352182menswear
outswear1144792outswear
swear85316852__swear
unbear889162un_bear
unclear936572unclear
unseal63315472uns_eal
unseam83313142uns_eam
unseat64221022uns_eat
unspeak1344792unspeak
unswept1246012unswept
unweary1335842un_weary
anear55420323an__ear
answerer1144273answerer
answers1037043answers
antbear935063antbear
antiwear1146123antiwear
besmear1134833besmear
endear74110013en_dear
eyewear1342623eyewear
forswear1443293forswear
gnawer10386953gnawe_r
inseam8329993ins_eam
insofar1043543insofar
instar6310013ins_tar
instead836203instead
insular7138703insular
inswept1245733inswept
knitwear1591463knitwear
knower1337083knowe_r
mishear1238393mishear
munster93710523munste_r
near45236503_n__ear
newer85717463_newe_r
nuclear936233nuclear
outswears1244303outswears
outwear1097713outwear
punster92911103punste_r
rewear93012003_rewear
sear47353843__s_ear
sewar85421103__sewar
shear85424833__shear
skiwear1442523skiwear
smear74416393__smear
spear75821063__spear
swears94114073__swears
sweat85628403__sweat
sweer84918573__sweer
ulster63712103ulste_r
unaware1038033unaw_are
unawed103914903unawe_d
unbar71913613un__bar
unbears998043un_bears
unclean946973unclean
undead82711903un_dead
under64624213un_de_r
underwear1344763underwear
undoer73113043undoe_r
undular837123undular
ungular836773ungular
unheard1136943un_heard
unideal837103unideal
uniter64619143unite_r
unlead73312373un_lead
unlearn735953un_learn
unread73412673un_read
unreal64414453un_real
unsawed112911503unsawe_d
unsay83212843uns__ay
unseals73212583uns_eals
unseams9338913uns_eams
unseared91113943uns_eared
unseats73012853uns_eats
unseen62012623uns_een
unsell63512543uns_ell
unsent63820963uns_ent
unset54532433uns_e_t
unsets64116163uns_ets
unsew83912693uns_e_w
unsewed112911023unsewed
unsewn9298393uns_ewn
unsews9379363uns_ews
unsex123512633uns_e_x
unsexy16296903uns_exy
unsharp1235543uns_harp
unshed10313773unshe_d
unshell1047113unshell
unsmart939603uns_mart
unsnag736393uns_nag
unsnap836203uns_nap
unsnarl7107153uns_narl
unsober967643unsober
unsowed112511053unsowe_d
unspeaks1443593unspeaks
unspent92610893unspent
unsteady1243513unsteady
unsteel738793unsteel
unstep839223unste_p
unsteps936213unsteps
unstrap946783unstrap
unswearing1444413unswearing
unswore1039053unswore
unsworn1046843unsworn
untread857413untread
unwary1239823un_w_ary
unweave1336363un_weave
unwed94114873un_we_d
unwell9349443un_well
unwept11389813un_wept
unwet84423173un_we_t
unwrap11126323un_wrap
upbear1096493u_pbear
uprear8168793u_prear
upsoar8105683ups_oar
upsweep1442573upsweep
upswell1242723upswell
upswept1443473upswept
uptear896783u_ptear
user45023003u_s_e_r
usher84517763u_she_r
usnea539393u_snea_
usneas638333u_sneas
wear75836723___wear

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271257.39318128.9
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.87522690.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.