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

469 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
unwit8441752(None) 
unfit84518561unfit
unit45140071un_it
unlit55025461unlit
unwet84423171unwet
unwits9389891unwits
knit85728142kn_it
nit37065942_n_it
outwit93014582outwit
pewit104622792pewit
pundit92914182pundit
snit46342472sn_it
sunlit61516102sunlit
twit76329062_twit
unai44824782unai_
unais53420772unais
unapt710421592unapt
unbid83214632unbid
unci65019462unci_
uncia75015162uncia
uncut73219172uncut
undid72415362undid
unfits93910292unfits
unfix15429032unfix
unfixt16398422unfixt
ungirt71112712ungirt
ungot61718062ungot
unhat81119262unhat
unhip10178822unhip
unite54828382un_ite
units54923432un_its
unity84918492un_ity
unknit1068592unknit
unlet54133332unlet
unmet74426392unmet
unmix14388972unmix
unmixt15378702unmixt
unpin72613242unpin
unrig61711412unrig
unrip72012862unrip
unset54532432unset
untie54425492untie
until53517742until
untwist1047712untwist
unwed94114872unwed
unwept11389812unwept
unwhite1336812unwhite
unwind102610542unwind
unwise9510802unwise
unwish1239092unwish
unwon84512342unwon
unzip16207622unzip
uplit76020802uplit
wit66563772__wit
adit56443653_adit
admit8319493admit
afrit8323173afrit
ait38093903__ait
alit46155693_alit
ambit94223693ambit
anent54931843anent
angst6415493angst
ani37751173an_i_
anil46437433an_il
anis45746463an_is
anoint6423633anoint
ant37270783an__t
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
audit62527883audit
aunt46553653aun__t
auntie64317703auntie
await85524493await
bait66556003_bait
bandit93821133bandit
bankit123617043bankit
befit105222663befit
bewig1138903bewig
binit76431583binit
bit57070893__bit
brit66350153_brit
bruit76126723bruit
bundist10310193bundist
bundt85824853bun_dt
bunt65850853bun__t
chit96937463_chit
confit113316403confit
crit65743713_crit
cubit94122883cubit
cunt66243673cun__t
davit93424593davit
dawt85435943daw_t
debit85727843debit
demit84832303demit
digit73825273digit
dimwit1237943dimwit
dit47071333__dit
dixit134420593dixit
doit56347853_doit
dowie94721143dowie
droit65127123droit
duit56241583_duit
dunite7315013dun_ite
dunlin739723dunlin
dunnite857333dunnite
dunt55746873dun__t
edit54934863_edit
emit65438413_emit
enact73525363enact
endite73817593endite
engirt71112613engirt
enlist6417043enlist
enmity1137483enmity
entia5318203entia
entity9312053entity
entwist1048803entwist
enwind10298083enwind
exit114428673_exit
fit66365453__fit
fixit154819303fixit
flit76539273_flit
frit77044473_frit
fruit85122223fruit
fundi96814913fundi_
fundic12389083fundic
funest94316863funest
fungi95014133fungi_
fungic12387813fungic
funkia1336343funkia
gait56150193_gait
git46266053__git
gnat56034433gn_at
godwit1137513godwit
grit55247243_grit
gunite7414403gun_ite
habit103027013habit
henbit111412003henbit
hit66569193__hit
hunkie133812383hunkie
hunt76445493hun__t
inapt73522693inapt
incite83618723incite
indict93115563indict
indie63721463indie
indite73520313indite
inept73622153inept
inert53234373inert
infix15337763infix
ingot61221063ingot
inia45024693in_ia
inlet53732403inlet
input7314653input
inset54430863inset
insist6314503insist
inti46626073inti_
intis55121633intis
intuit6314083intuit
intwist1038043intwist
invite93715023invite
inwind10268403inwind
it28455683___it
iwis77117003_iwis
junket173815023junket
junkie17339603junkie
kit78559873__kit
kiwi113211793kiwi_
kiwis12328583kiwis
knelt94617683knelt
knits93914743kn_its
knot85630503kn_ot
knout95018263knout
krait94726773krait
kunzite2053503kunzite
legit61323503legit
lewis85315843lewis
licit74327683licit
limit73126333limit
lit39377313__lit
lunet56835423lun_et
lungi65516053lungi_
lungis77113023lungis
lunt46148843lun__t
merit7339183merit
muni65824403mun_i_
munis75022003mun_is
muntin82915183muntin
muskit122813253muskit
naif76839013_naif
nail45838653_nail
neat46356783_neat
neif75429483_neif
neist54628443_neist
nest45548733_nest
net36670293_n_et
nett46643233_nett
newie81813483newie
newt76933743_newt
next116631083_next
nib56745183_n_ib
nil36144193_n_il
nim57142953_n_im
nip56945983_n_ip
nite45943583_n_ite
nits45741643_n_its
nitwit938593nitwit
nix106932833_n_ix
noil46133243_noil
noir46722433_noir
not39474663_n_ot
nowt78833753_nowt
nubia7311223nubia
nudie65118673nudie
nudist73813323nudist
nudity1037993nudity
nuncio837973nuncio
nut36651963_n_ut
obit66837073_obit
omit65337363_omit
oncet74626543oncet
onset54730173onset
ontic74418573ontic
orbit73622053orbit
outfit93014943outfit
outhit92818463outhit
outsit63620883outsit
outwait10411763outwait
outwith13279133outwith
outwits103110863outwits
outwrit10411413outwrit
pandit93820753pandit
peewit111110903peewit
petit74332653petit
pewits112810683pewits
pipit95224873pipit
pit56471923__pit
plait75631573plait
posit75833333posit
pulpit10310933pulpit
pundits10379293pundits
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
punnet83518843punnet
punt65747203pun__t
qubit164218983qubit
quit136136513_quit
quoit143819863quoit
rawin85521473rawin
recit75235103recit
refit84230063refit
relit55340683relit
remit75737223remit
resit54241043resit
rewet85135153rewet
rewin85623963rewin
runic73615773run_ic
runlet63821413runlet
runout6414873runout
runt46647983run__t
runway12105973runway
sennit63117923sennit
shit76745933_shit
sit35877753__sit
skit85437523_skit
slit46250103_slit
smit65138403_smit
snail57020203snail
snib66522973sn_ib
snip66424653sn_ip
snits54124833sn_its
snoot55030133snoot
snort54833753snort
snot44745443sn_ot
snout54530633snout
spait75631603spait
spit65545083_spit
split75729013split
sprit76736403sprit
submit10312673submit
suit45649873_suit
summit10311543summit
sunket103721363sunket
sunset63723633sunset
sunsuit748693sunsuit
sunwise1036433sunwise
swat77244443_swat
swift116818053_swift
swig85818023_swig
swim96221393_swim
swith115917403_swith
swot75134653_swot
tacit76333673tacit
tawie84819813tawie
tit36771043__tit
toit46353063_toit
towie85821873towie
trait56940843trait
tunic74018223tun_ic
turbit8715113turbit
twat75831513_twat
twig87615773_twig
twin76023083_twin
twist86820983_twist
twits86015793_twits
twixt155512483_twixt
un28341133un___
unakin10310963unakin
unakite1138743unakite
unarm7314453unarm
unary8315993unary
unau43924153un_au
unaus53216573unaus
unawed103914903unawed
unban72114333unban
unbar71913613unbar
unbe65319273un_be
unbelt83015693unbelt
unbent83216593unbent
unbind93011423unbind
unbolt83013893unbolt
unbox1438753unbox
unbuilt948003unbuilt
uncap9312283uncap
uncast84215713uncast
unchic1338643unchic
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
uncle7317053uncle
unclip1046993unclip
unco66021403un_co
uncoil8811853uncoil
uncos74117033uncos
uncoy104111413uncoy
uncus74014983uncus
uncute82912133uncute
unde55825483un_de
undee65327273undee
under64624213under
undies73821963undies
undine7817263undine
undo55620153un_do
undue66715553undue
undy85015163un_dy
unfair936233unfair
unfaith1345783unfaith
unfed94614223unfed
unfelt92413463unfelt
unfitly1335573unfitly
ungird887973ungird
unguis738443unguis
unhair937333unhair
unhats91110623unhats
unhitch1543053unhitch
unhurt9311253unhurt
unific1137463unific
unify113611113unify
union54519793union
united74421543un_ited
uniter64619143un_iter
unites65024853un_ites
unjam1448723unjam
unjoint1449233unjoint
unjust1337873unjust
unkent103116053unkent
unkept123710873unkept
unkind113310573unkind
unkink9308713unkink
unknits1135553unknits
unknot1037413unknot
unlaid7311753unlaid
unlay84613703unlay
unled64021073unled
unlike102614063unlike
unlink104011013unlink
unlive92712333unlive
unman72715423unman
unmeet83815743unmeet
unmew103610073unmew
unmiter9310393unmiter
unmitre936993unmitre
unnail6410583unnail
unpaid939473unpaid
unpeg8309363unpeg
unpen72913573unpen
unpent83117373unpent
unpick1446903unpick
unpile81914323unpile
unpins82312383unpins
unplait948603unplait
unquiet16310663unquiet
unrent63219783unrent
unrest62918853unrest
unrigs7159003unrigs
unripe82012093unripe
unrips8199453unrips
unroot6315553unroot
uns35936753un__s
unsaid7411833unsaid
unsay83212843unsay
unseat64221023unseat
unsent63820963unsent
unsets64116163unsets
unsew83912693unsew
unsex123512633unsex
unshift1387413unshift
unship1148033unship
unshut939013unshut
unsight1137483unsight
unspilt938853unspilt
unsplit956563unsplit
unswept1246013unswept
untidy1059153untidy
untied73720813untied
unties64326923unties
unto45824283un_to
untrim8310673untrim
untwine1038623untwine
untwists1144623untwists
unveil957343unveil
unvext1658173unvext
unwary1239823unwary
unweight1544743unweight
unwell9349443unwell
unwinds11286733unwinds
unwiser1037123unwiser
unwisest1165123unwisest
unwitted1237543unwitted
unworn93411333unworn
unwove12238883unwove
unwrap11126323unwrap
unzips17175273unzips
upgirt9117263upgirt
uplift114610653uplift
uppity1335103uppity
upset73222593upset
uptilt8410803uptilt
upwaft1444943upwaft
upwind12255823upwind
urbia7311133urbia
ureic74514463ureic
uric63624933u_ric
ursid6311483ursid
ut28647033u___t
visit8320963visit
vomit102622573vomit
wait75553693_wait
wat67378923__wat
wet65966623__wet
whit104834173_whit
wig76740383__wig
wilt76246293__wilt
win66456293__win
wis66552333__wis
wist78049293__wist
wite75443273__wite
with105730473__with
wits76044873__wits
wiz156434153__wiz
wot610467483__wot
writ75537913_writ
yowie114616453yowie
ywis105313103_ywis
zit126049993__zit
zizit13313273zizit
zowie174313843zowie

Search took 5 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 Filter178691836670.1261418182.5
2DLD Change Limit836674693.82621868.0
3Display Results4694690.1263722.2
 (SQL Overall)1786914694.07843818.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.