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

326 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
unseats7301285(None) 
unseals73212571unseals
unseams9338911unseams
unseat64221021unseat_
unsets64116161unse_ts
inseams9307902inseams
insects93710842insects
inserts74013992inserts
insets64016132inse_ts
miseats92815782miseats
neats55931902_n_eats
onsets64013542onse_ts
reseats74319582reseats
seats54844342__seats
sunsets72911572sunse_ts
unbears998042unbears
unbelts9237662unbelts
unhats91110622un_hats
unleads8228622unleads
unrests7229462unrests
unsays9399542uns_ays
unseal63315472unsea_l
unseam83313142unsea_m
unseated91317682unseated
unsells73210772unsells
unsent63820962unsent_
unset54532432unse_t_
unsews9379362unse_ws
unsexes14248922unsexes
unsnags835462unsnags
unsnaps935422unsnaps
unspeaks1443592unspeaks
unstate71916212unstate
unstates81314992unstates
unswears1144022unswears
upbeats1195732upbeats
upsets8409682upse_ts
usneas638332usnea_s
absents93510723absents
anears63717183an_ears
anneals7449943anneals
ansate64517863ans_ate
assents74512223assents
asserts74311793asserts
assets65617663asse_ts
beats76042243__beats
besets85718803bese_ts
bisects1137133bisects
bleats85518613_bleats
caseate9314783caseate
caseates10313713caseates
caveats1239803caveats
cheats114519543_cheats
cleats84919313_cleats
consents102715893consents
cosets85824403cose_ts
cuneate9311723cun_eate
cushats12288273cushats
defeats113511233defeats
deserts82513053deserts
disseats93211503disseats
eats47054873___eats
endears83710053endears
enneads834733enneads
enserfs1035483enserfs
ensheath14133963ensheath
ensheaths15153133ensheaths
entreats839773entreats
exsects1655573exsects
exserts1467013exserts
feats86432753__feats
funfests14253563funfests
gnats65217713gn__ats
greats76318393_greats
gunboats1144823gunboats
gunsels8338133gunse_ls
gunshots1244373gunshots
gussets837443gusse_ts
heats85838403__heats
incents92414533incents
incepts11238283incepts
incests92711383incests
indents83114663indents
inerts64517023in_erts
infects12279713infects
infests10279793infests
ingests83210983ingests
injects16257453injects
inlets63915573inle_ts
inseam8329993insea_m
insect83916583insect_
insert64325253insert_
inset54430863inse_t_
insheath14114423insheath
insheaths15183503insheaths
insists739083insists
inspans937803inspans
inspects1255863inspects
instals7611713instals
instants8910153instants
instars7411133instars
instate71616483instate
instates81615833instates
insults7268963insults
intents72115703intents
intreats8311543intreats
invents102812053invents
inverts103211953inverts
invests10319683invests
junkets18377623junke_ts
kismats13257843kismats
kneads11357093kn_eads
lunets66914763lun_e_ts
meats75034053__meats
miseat82925703miseat_
misseats104011683misseats
muscats1138933muscats
neaps75618323_n_eaps
nears55529423_n_ears
neat46356783_n_eat_
neath86020283_n_eath
nerts55924983_n_erts
nests55728003_n_ests
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
numbats1137673numbats
nutmeats1044463nutmeats
onset54730173onse_t_
orgeats838353orgeats
outeats72215703outeats
outserts8309803outserts
outsets73514923outse_ts
peats76140193__peats
pesetas938753pesetas
pleats85218593_pleats
punnets9409263punne_ts
reheats104513523reheats
repeats94316053repeats
reseals73917663reseals
reseat64131493reseat_
reseaus74012153reseaus
resects94115593resects
resents74221223resents
resets65427613rese_ts
roseate7613453roseate
rosets65819953rose_ts
runlets73310773runle_ts
russets738163russe_ts
scats75930603__scats
seals54839693__seals
seams75731663__seams
sears54744913__sears
seas45755273__sea_s
seat47575563__seat_
sects75622893__sects
septs75420603__septs
sets45549503__se_ts
setts55124323__setts
sexts125118383__sexts
skats94621543__skats
slats55436903__slats
sneaks104312493sn_eaks
sneaps84510863sn_eaps
spats75031383__spats
stats55933363__stats
subsects12267903subsects
subsets92813103subse_ts
sunbeams1243963sunbeams
sunbelts1044673sunbelts
sunkets113511283sunke_ts
sunset63723633sunse_t_
sunspots1045083sunspots
sunsuits845963sunsuits
swats85726863__swats
sweats94814613_sweats
teats55636813__teats
threats104311673threats
treats64821693_treats
unais53420773un__ais
unaus53216573un__aus
unbans81912623un_bans
unbars82113033un_bars
unbear889163unbea_r
unbeaten1038013unbeaten
unbelt83015693unbelt_
unbends10236993unbends
unbent83216593unbent_
unbolts9247803unbolts
uncaps1039813un_caps
uncast84215713un_cast
uncials92510523uncials
uncrate9415953uncrate
uncrates10314563uncrates
uncreate10311353uncreate
uncreates11310433uncreates
undead82711903undea_d
underacts1248583underacts
underate9918603underate
undereats10310223undereats
undraws1136893undraws
unearth1037063un_earth
unearths1144353un_earths
unease63816643un_ease
uneases73316263un_eases
uneasy9278853un_easy
uneaten7412543un_eaten
unfelt92413463unfelt_
unfits93910293un_fits
unguents945153unguents
unhat81119263un_hat_
unheard1136943unheard
unheated121514553unheated
unhelms1234223unhelms
unisexes1554613unisexes
units54923433un__its
unjams1555703un_jams
unkent103116053unkent_
unkept123710873unkept_
unknits1135553unknits
unknots1144303unknots
unlays93810493un_lays
unlead73312373unlea_d
unlearn735953unlearn
unlearns844453unlearns
unleash1034963unleash
unless62413073unle_ss
unlet54133333unle_t_
unloads8278523unloads
unmans82211993un_mans
unmeant9510903unmeant
unmeet83815743unmeet_
unmet74426393unme_t_
unmews11326523unme_ws
unpegs9256233unpe_gs
unpens82511013unpe_ns
unpent83117373unpent_
unplaits1044813unplaits
unread73412673unrea_d
unready11215943unready
unreal64414453unrea_l
unreels7258313unreels
unrent63219783unrent_
unrest62918853unrest_
unroots738563unroots
unsafe9310693uns_afe
unsaid7411833uns_aid
unsated83419933uns_ated
unsawn9317463uns_awn
unsay83212843uns_a_y
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseating10713203unseating
unseen62012623unse_en
unsell63512543unse_ll
unsettle866063unsettle
unsettles964653unsettles
unsew83912693unse__w
unsewed112911023unsewed
unsewn9298393unse_wn
unsex123512633unse__x
unsexed152410253unsexed
unsexy16296903unse_xy
unsharp1235543unsharp
unsheathe15174753unsheathe
unsheathes16183843unsheathes
unshells1145923unshells
unshifts1444033unshifts
unships1237203unships
unshut939013unshut_
unsights1244623unsights
unsmart939603unsmart
unsnag736393unsna_g
unsnap836203unsna_p
unsnarl7107153unsnarl
unsnarls894883unsnarls
unspeak1344793unspea_k
unspent92610893unspent_
unstack1337373unstack
unstacks1446043unstacks
unstated91615813unstated
unsteady1243513unsteady
unsteels845793unsteels
unsteps936213unsteps
unstops936993unstops
unstraps1045983unstraps
unswathe1444603unswathe
unswathes1544213unswathes
unswear1035003unswea_r
unswept1246013unswept_
unteach1246143unteach
untreads936223untreads
unveils1045753unveils
unvext1658173unvext_
unweary1335843unweary
unweave1336363unweave
unweaves1436143unweaves
unwept11389813unwept_
unwet84423173unwe_t_
unwits9389893un_wits
unwraps1255513unwraps
upbears1195423upbears
upbeat10911513upbeat_
upheaps1494233upheaps
upleaps1185233upleaps
uprears9107493uprears
upsends10265293upsends
upsent83314063upsent_
upset73222593upse_t_
upshots1235193upshots
upsoars985413upsoars
upstarts10165273upstarts
upstate91610493upstate
upstates10189643upstates
uptears9106453uptears
ureas55826013u_rea_s
urtexts1433143urtexts
users55817573u_se_rs
uses44931113u_se__s
usnea539393usnea__
usuals637783u_suals
uveas84912283u_vea_s
wheats125013223_wheats
wiseass1035823wiseass
wisents10249063wisents

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.390458182.1
2DLD Change Limit1340273265.81323056.4
3Display Results3263260.1102963.6
 (SQL Overall)1786913266.31328305.2
 
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.