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

408 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
unseat6422102(None) 
unseal63315471unseal
unseam83313141unseam
unseats73012851unseats
unsent63820961unsent
unset54532431unse_t
inseam8329992inseam
insect83916582insect
insert64325252insert
inset54430862inse_t
miseat82925702miseat
neat46356782_n_eat
onset54730172onse_t
reseat64131492reseat
seat47575562__seat
sunset63723632sunse_t
unbear889162unbear
unbelt83015692unbelt
unbent83216592unbent
undead82711902undead
unfelt92413462unfelt
unhat81119262un_hat
unkent103116052unkent
unkept123710872unkept
unlead73312372unlead
unlet54133332unle_t
unmeant9510902unmeant
unmeet83815742unmeet
unmet74426392unme_t
unpent83117372unpent
unread73412672unread
unreal64414452unreal
unrent63219782unrent
unrest62918852unrest
unsay83212842uns_ay
unseals73212572unseals
unseams9338912unseams
unseated91317682unseated
unseen62012622unseen
unsell63512542unsell
unsets64116162unsets
unsew83912692unse_w
unsewn9298392unsewn
unsews9379362unsews
unsex123512632unse_x
unsexy16296902unsexy
unshut939012unshut
unsmart939602unsmart
unsnag736392unsnag
unsnap836202unsnap
unspeak1344792unspeak
unspent92610892unspent
unstate71916212unstate
unswear1035002unswear
unswept1246012unswept
unvext1658172unvext
unwept11389812unwept
unwet84423172unwe_t
upbeat10911512upbeat
upsent83314062upsent
upset73222592upse_t
usnea539392usnea_
usneas638332usneas
absent84016993absent
anear55420323an_ear
anent54931843an_ent
anneal64812293anneal
ansa45927773ans_a_
ansae55720973ans_ae
ansate64517863ans_ate
asea46327183_asea_
assent65119953assent
assert64922583assert
asset55932263asse_t
basest84720493basest
beat66168303__beat
beset76739133bese_t
bisect10312873bisect
bleat75737003_bleat
caseate9314783caseate
caveat11417723caveat
cheat105732453_cheat
cleat76335063_cleat
consent93723113consent
coset75748843cose_t
cuneal8611513cun_eal
cuneate9311723cun_eate
cushat113513693cushat
defeat103817163defeat
densest83112473densest
desert72725493desert
disseat83816923disseat
dunnest83312263dunnest
eat36989053___eat
endear74110013endear
ennead736253ennead
enserf9310763enserf
ensheath14133963ensheath
entreat7315263entreat
exsect1558503exsect
exsert13414363exsert
feat76458223__feat
funest94316863fun_est
funfest13348083funfest
funnest102912003funnest
gnat56034433gn__at
great66034243_great
gunboat1047363gunboat
gunsel7339853gunse_l
gunsels8338133gunsels
gunshot1156643gunshot
gusset7316433gusse_t
heat77061423__heat
hereat93527413hereat
incent83320723incent
incept102712753incept
incest82918743incest
indent73021243indent
inept73622153in_ept
inert53234373in_ert
infect113413443infect
infest93315433infest
ingest73119003ingest
inject153210233inject
inlet53732403inle_t
inseams9307903inseams
insects93710843insects
inserts74013993inserts
insets64016133insets
insheath14114423insheath
insist6314513insist
inspan837513inspan
inspect1138463inspect
instal6712193instal
instant7815343instant
instar6310013instar
instate71616483instate
instead836203instead
insult62813673insult
inswept1245733inswept
intent63122773intent
intreat7416303intreat
invent93316363invent
invert94120083invert
invest93014843invest
junket173815023junke_t
kismat123011673kismat
knead10429663kn_ead
knelt94617683kn_elt
lunet56835423lun_e_t
luniest73516993luniest
meat66359603__meat
miseats92815783miseats
misseat93617233misseat
muscat10314653muscat
neap66927013_n_eap
near45236503_n_ear
neath86020283_n_eath
neats55931903_n_eats
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
next116631083_n_ext
nonmeat9312773nonmeat
nudest74113833nudest
numbat10312083numbat
nutmeat947953nutmeat
oncet74626543once_t
onsets64013543onsets
orgeat7515033orgeat
outeat62824533outeat
outsat62920283outs_at
outsert72819513outsert
outset64027453outse_t
peat65967933__peat
peseta8310573peseta
pleat74734473_pleat
pungent10311233pungent
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
reheat94423943reheat
repeat85127213repeat
resat55139683res_at
reseal64819643reseal
reseats74319583reseats
reseau64216213reseau
resect84424703resect
resent63833623resent
reset55051863rese_t
roseate7613453roseate
roset55945243rose_t
runlet63821413runle_t
russet6319433russe_t
sat36288483__s_at
scat65848373__scat
sea36161293__sea_
seal45654373__seal
seam66645973__seam
sear47353843__sear
seas45755273__seas
seats54844343__seats
sect67443623__sect
sent46963013__sent
sept65844363__sept
set36681253__se_t
seta45637313__seta
sett45949053__sett
sext117338093__sext
shat76456603__shat
skat87037903__skat
slat46959023__slat
sneak96016173sn_eak
sneap75514823sn_eap
spat66548523__spat
stat47352693__stat
subsea82610193subsea_
subsect112611843subsect
subset83122583subse_t
sunbeam1146053sunbeam
sunbelt939233sunbelt
sunket103721363sunke_t
sunsets72911573sunsets
sunspot947163sunspot
sunsuit748693sunsuit
swat77244443__swat
sweat85628403_sweat
teat45963633__teat
tensest72713313tensest
threat95020463threat
treat56240353_treat
unadept1046603unadept
unai44824783un__ai
unapt710421593un_apt
unau43924153un__au
unban72114333un_ban
unbar71913613un_bar
unbe65319273unbe__
unbears998043unbears
unbeaten1038013unbeaten
unbelts9237663unbelts
unbend9269773unbend
unblest9411813unblest
unbolt83013893unbolt
uncap9312283un_cap
uncast84215713uncast
uncia75015163uncia_
unciae83215313unciae
uncial83715223uncial
unclad938913unclad
unclean946973unclean
unclear936573unclear
uncleft1257493uncleft
uncrate9415953uncrate
uncreate10311353uncreate
uncut73219173un_cut
unde55825483unde__
undee65327273unde_e
under64624213unde_r
underact11311513underact
underate9918603underate
undereat9313903undereat
undraw1037813undraw
undreamt1156543undreamt
undrest8313013undrest
unearth1037063un_earth
unease63816643un_ease
uneasy9278853un_easy
uneaten7412543un_eaten
unfed94614223unfe_d
unfit84518563un_fit
unfixt16398423unfixt
ungirt71112713ungirt
ungot61718063un_got
ungual738183ungual
unguent839123unguent
unhats91110623un_hats
unheard1136943unheard
unheated121514553unheated
unhelm1136863unhelm
unhewn12285253unhewn
unhurt9311253unhurt
unideal837103unideal
unisex1358353unise_x
unit45140073un__it
unjam1448723un_jam
unjust1337873unjust
unkempt1544763unkempt
unkend11309223unkend
unknit1068593unknit
unknot1037413unknot
unlay84613703un_lay
unleads8228623unleads
unlearn735953unlearn
unlearnt846403unlearnt
unleash1034963unleash
unled64021073unle_d
unless62413073unless
unlit55025463un_lit
unload73010803unload
unman72715423un_man
unmesh1145793unmesh
unmew103610073unme_w
unmews11326523unmews
unmixt15378703unmixt
unpeg8309363unpe_g
unpegs9256233unpegs
unpen72913573unpe_n
unpens82511013unpens
unplait948603unplait
unready11215943unready
unreel63612933unreel
unrests7229463unrests
unroot6315553unroot
uns35936753uns___
unsafe9310693unsafe
unsaid7411833unsaid
unsated83419933uns_ated
unsawn9317463unsawn
unsays9399543unsays
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseating10713203unseating
unsells73210773unsells
unsettle866063unsettle
unsewed112911023unsewed
unsexed152410253unsexed
unsexes14248923unsexes
unsexual1543713unsexual
unsharp1235543unsharp
unsheathe15174753unsheathe
unshed10313773unshed
unshell1047113unshell
unshift1387413unshift
unship1148033unship
unshod1067603unshod
unsight1137483unsight
unsilent849603unsilent
unsnags835463unsnags
unsnaps935423unsnaps
unsnarl7107153unsnarl
unsold71410513unsold
unsown9328433unsown
unspeaks1443593unspeaks
unspilt938853unspilt
unsplit956563unsplit
unspun865793unspun
unstack1337373unstack
unstated91615813unstated
unstates81314993unstates
unsteady1243513unsteady
unsteel738793unsteel
unstep839223unstep
unsteps936213unsteps
unstop837473unstop
unstrap946783unstrap
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
unswathe1444603unswathe
unswears1144023unswears
unteach1246143unteach
untread857413untread
unused72012883unuse_d
unusual743943unusual
unveil957343unveil
unweary1335843unweary
unweave1336363unweave
unwed94114873unwe_d
unwell9349443unwell
unwisest1165123unwisest
unwit84417523un_wit
unwrap11126323unwrap
upbear1096493upbear
upbeats1195733upbeats
upheap13105213upheap
upleap10106843upleap
upleapt11116863upleapt
uprear8168793uprear
upsend9356883upsend
upsets8409683upsets
upshot1138453upshot
upsoar8105683upsoar
upstart9159753upstart
upstate91610493upstate
upswept1443473upswept
uptear896783uptear
urea46528053u_rea_
ureal56722683u_real
ureas55826013u_reas
urgent73816043urgent
ursa44116903urs_a_
ursae55214453urs_ae
urtext1337433urtext
use36835163u_se__
used55722823u_se_d
user45023003u_se_r
users55817573u_sers
uses44931113u_se_s
usual5310183u_sual
uvea74712653u_vea_
uveal84411073u_veal
uveas84912283u_veas
wheat114924573_wheat
wisent93516343wisent
wisest95016443wisest

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164085.04622337.7
3Display Results4084080.1432853.1
 (SQL Overall)1786914085.56232127.1
 
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.