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 “unswears” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
unswears114402(None) 
unswear1035001unswear_
answers1037042answe_rs
outswears1244302outswears
swears94114072__swears
unbears998042un_bears
unseals73212582uns_eals
unseams9338912uns_eams
unseats73012852uns_eats
unspeaks1443592unspeaks
unweary1335842un_weary
anears63717183an__ears
answer936893answe_r_
answerers1243743answerers
antbears1044963antbears
besmears1234543besmears
endears83710053en_dears
forswears1543243forswears
gnawers11356393gnawe_rs
inseams9307903ins_eams
instars7411133ins_tars
insulars8137323insulars
knowers1436353knowe_rs
menswear1352183menswear_
mishears1338323mishears
munsters104010553munste_rs
nears55529423_n__ears
outswear1144793outswear_
outwears1197263outwears
punsters103310583punste_rs
rewears102911043_rewears
sears54744913__s_ears
sewars94018633__sewars
shears93820903__shears
smears84714433__smears
spears84019473__spears
swear85316853__swear_
sweats94814613__sweats
ulsters72711983ulste_rs
unaware1038033unaw_are
unawares1137053unaw_ares
unbars82113033un__bars
unbear889163un_bear_
unclear936573unclear_
undoers82910583undoe_rs
unheard1136943un_heard
uniters73814173unite_rs
unleads8228623un_leads
unlearn735953un_learn
unlearns844453un_learns
unsays9399543uns__ays
unseal63315473uns_ea_l
unseam83313143uns_ea_m
unseared91113943uns_eared
unseat64221023uns_ea_t
unsells73210773uns_ells
unsets64116163uns_e_ts
unsews9379363uns_e_ws
unsexes14248923uns_exes
unsharp1235543uns_harp
unshells1145923unshells
unsmart939603uns_mart
unsnags835463uns_nags
unsnaps935423uns_naps
unsnarl7107153uns_narl
unsnarls894883uns_narls
unspeak1344793unspea_k
unsteady1243513unsteady
unsteels845793unsteels
unsteps936213unste_ps
unstraps1045983unstraps
unswearing1444413unswearing
unswept1246013unswe_pt
unswore1039053unsw_ore
unsworn1046843unsw_orn
untreads936223untreads
unwary1239823un_w_ary
unweave1336363un_weave
unweaves1436143un_weaves
unwraps1255513un_wraps
upbears1195423u_pbears
uprears9107493u_prears
upsoars985413ups_oars
upsweeps1541773upsweeps
upswells1342623upswells
uptears9106453u_ptears
users55817573u_s_e_rs
ushers94415533u_she_rs
usneas638333u_snea_s
wears86030303___wears

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.420425454.8
2DLD Change Limit146162906.58022213.1
3Display Results90900.0303000.0
 (SQL Overall)178691907.03025418.3
 
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.