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

191 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
unseams933891(None) 
inseams9307901inseams
unseals73212571unseals
unseam83313141unseam_
unseats73012851unseats
inseam8329992inseam_
seams75731662__seams
sunbeams1243962sunbeams
unbears998042unbears
unhelms1234222unhelms
unjams1555702un_jams
unleads8228622unleads
unsays9399542uns_ays
unseal63315472unsea_l
unseamed111210662unseamed
unseat64221022unsea_t
unsells73210772unsells
unsets64116162unse_ts
unsews9379362unse_ws
unsexes14248922unsexes
unsnags835462unsnags
unsnaps935422unsnaps
unspeaks1443592unspeaks
unswears1144022unswears
usneas638332usnea_s
anears63717183an_ears
anneals7449943anneals
beams95328173__beams
beseems1175913beseems
breams104815043_breams
creams104715253_creams
dreams94513983_dreams
dunams937833dun__ams
endears83710053endears
enemas8812003en_emas
engrams1038073engrams
enneads834733enneads
enserfs1035483enserfs
fleams115011943_fleams
gleams94812253_gleams
gunsels8338133gunse_ls
insects93710843insects
inserts74013993inserts
insets64016133inse_ts
inspans937803inspans
instals7611713instals
instars7411133instars
kneads11357093kn_eads
meseems1165603meseems
miseats92815783miseats
museums1134563museums
neaps75618323_n_eaps
nears55529423_n_ears
neats55931903_n_eats
neems77316293_n_eems
nemas75321573_n_emas
neums75414253_n_eums
nizams1735413_nizams
onsets64013543onse_ts
outbeams1236063outbeams
reams75729623__reams
reseals73917663reseals
reseats74319583reseats
reseaus74012153reseaus
reteams9339563reteams
scams94423973__scams
screams114810623screams
seals54839693__seals
seam66645973__seam_
seamy105921273__seamy
sears54744913__sears
seas45755273__sea_s
seats54844343__seats
seems75525023__seems
shams105829413__shams
slams74927903__slams
sneaks104312493sn_eaks
sneaps84510863sn_eaps
spams94922193__spams
steams84916903_steams
streams94713373streams
sunbeam1146053sunbeam_
sunbeamy1542353sunbeamy
sunsets72911573sunse_ts
teams75726513__teams
ulemas888963u_lemas
unais53420773un__ais
unarms839243un_arms
unaus53216573un__aus
unbans81912623un_bans
unbars82113033un_bars
unbear889163unbea_r
unbelts9237663unbelts
unbends10236993unbends
uncaps1039813un_caps
uncials92510523uncials
unclamp1344993unclamp
unclamps1443693unclamps
undead82711903undea_d
underarms1246733underarms
undraws1136893undraws
undreamt1156543undreamt
unease63816643un_ease
uneases73316263un_eases
uneasy9278853un_easy
unhats91110623un_hats
unheard1136943unheard
unhelm1136863unhelm_
unisexes1554613unisexes
unjam1448723un_jam_
unlays93810493un_lays
unlead73312373unlea_d
unlearn735953unlearn
unlearns844453unlearns
unleash1034963unleash
unless62413073unle_ss
unloads8278523unloads
unmans82211993un_mans
unmeant9510903unmeant
unmews11326523unme_ws
unpegs9256233unpe_gs
unpens82511013unpe_ns
unread73412673unrea_d
unready11215943unready
unreal64414453unrea_l
unreels7258313unreels
unrests7229463unrests
unsafe9310693uns_afe
unsaid7411833uns_aid
unsawn9317463uns_awn
unsay83212843uns_a_y
unsealed91513623unsealed
unseaming1278113unseaming
unseared91113943unseared
unseated91317683unseated
unseemly1343763unseemly
unseen62012623unse_en
unsell63512543unse_ll
unsent63820963unse_nt
unset54532433unse__t
unsew83912693unse__w
unsewed112911023unsewed
unsewn9298393unse_wn
unsex123512633unse__x
unsexed152410253unsexed
unsexy16296903unse_xy
unshamed14148053unshamed
unsharp1235543unsharp
unshells1145923unshells
unships1237203unships
unsmart939603unsmart
unsnag736393unsna_g
unsnap836203unsna_p
unsnarl7107153unsnarl
unsnarls894883unsnarls
unspeak1344793unspea_k
unstack1337373unstack
unstacks1446043unstacks
unstate71916213unstate
unstates81314993unstates
unsteady1243513unsteady
unsteels845793unsteels
unsteps936213unsteps
unstops936993unstops
unstraps1045983unstraps
unswear1035003unswea_r
untame82513603un_tame
unteach1246143unteach
untreads936223untreads
untrims938613untrims
unveils1045753unveils
unweary1335843unweary
unweave1336363unweave
unweaves1436143unweaves
unwraps1255513unwraps
upbears1195423upbears
upbeats1195733upbeats
upheaps1494233upheaps
upleaps1185233upleaps
uprears9107493uprears
upsends10265293upsends
upsets8409683upse_ts
upsoars985413upsoars
uptears9106453uptears
ureas55826013u_rea_s
users55817573u_se_rs
uses44931113u_se__s
usnea539393usnea__
usuals637783u_suals
uveas84912283u_vea_s
wiseass1035823wiseass

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.420425454.8
2DLD Change Limit1340271916.34621119.9
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.82926166.5
 
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.