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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

239 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
duet5644626(None) 
deet57356581deet
diet57357541diet
duct75735461duct
due45249861due_
duel56729701duel
dues56045501dues
duets65323881duets
duit56241581duit
dunt55746871dunt
dust57142531dust
duvet9321871duvet
suet46754821suet
abet610547942abet
adult63520652adult
adust64117452adust
aunt46553652aunt
beet66457542beet
bet58376672_bet
blet66247672blet
bluet75631192bluet
bunt65850852bunt
buret77444012buret
bust65947782bust
but55963022bu_t
bute66739672bute
butt65143742butt
cruet74831842cruet
cue57544182cue_
cued76329562cued
cues65438982cues
culet76040342culet
cult66541152cult
cunt66243672cunt
curet75447642curet
curt67051712curt
cut57957662cu_t
cute66440452cute
daft85537252daft
dart55857872dart
date56443322date
daunt65929082daunt
daut56443562daut
dawt85435942dawt
de37049552d_e_
deb66342692d_eb
debt77139022debt
dee47665822d_ee
deed65340902deed
deem75432892deem
deep76031882deep
deer56739022deer
dees56356632dees
deets65330242deets
def76546722d_ef
deft85540222deft
del46752752d_el
delt57855272delt
den47554342d_en
dent57158412dent
dev76033772d_ev
dew77139922d_ew
dex116936882d_ex
dey77243372d_ey
die46759662die_
died66137862died
diel59034612diel
dies55653532dies
diets66026642diets
dint56759062dint
dipt77339332dipt
dirt55550392dirt
dit47071342d_it
dite55547562dite
doat56947672doat
doe47361952doe_
doer57734702doer
does56554472does
doest65829522doest
doeth9411982doeth
doit56347852doit
dolt56649422dolt
dost57248352dost
dot47573182d_ot
dote55442882dote
doubt8720092doubt
drat56247832drat
dree56638322dree
dreg66821652dreg
drek96321092drek
drest65530342drest
drew86221672drew
duad66521412duad
dual55928172dual
dub66642202du_b
dubs78432192dubs
ducat86225902ducat
duce76933502duce
duces86327472duces
duci76422622duci
duck115929172duck
ducts85319892ducts
dud56737602du_d
dude65629672dude
duded84417132duded
dudes75424372dudes
duds65530152duds
duels65619232duels
dueted84113592dueted
duff114326642duff
dug58138692du_g
dugs614832282dugs
duh77930382du_h
dui46433382du_i
duits65021882duits
duke95628102duke
duked115218462duked
dukes105023472dukes
dulcet9314492dulcet
dull56430442dull
duly85323032duly
duma75524452duma
dumb97124102dumb
dump95927092dump
dun46545582du_n
dune56137582dune
dunes65332172dunes
dung66328432dung
dunk96228572dunk
duns55140432duns
dunts65828412dunts
duo48536142du_o
duos56728132duos
dup67637882du_p
dupe76630602dupe
duped95118322duped
duper85519002duper
dupes86425932dupes
dups75929512dups
dura55232112dura
dure56341812dure
dured75025402dured
dures65635922dures
durn56127632durn
duro56228022duro
durr55624352durr
durst66125172durst
dusk95724152dusk
dusts65923562dusts
dusty96018332dusty
duty85321452duty
duvets1039222duvets
dwelt94316522dwelt
dye75334842dye_
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
educt85017102educt
et26964192__et
feet75352212feet
fet66471632_fet
fret75845042fret
fuel76824732fuel
fumet105630222fumet
get47467462_get
guest65225922guest
gust55240702gust
gut46753852gu_t
haet75659502haet
het67674312_het
hue66642302hue_
hued86925852hued
hues75235232hues
hunt76445492hunt
hurt77142572hurt
hut66457292hu_t
jet106754822_jet
just115433342just
jut105944012ju_t
jute115327892jute
keet85347352keet
khet116328632khet
kue76631872kue_
kues86426782kues
leet45957902leet
let36481472_let
lues45943552lues
lunet56835422lunet
lunt46148842lunt
lust47442602lust
lute46341012lute
meet65350552meet
met56072432_met
must65145442must
mut58357182mu_t
mute65136872mute
mutt65739402mutt
net36670292_net
nut36651962nu_t
oust46747442oust
out38072152ou_t
pet56477302_pet
poet65552902poet
punt65747202punt
put55759072pu_t
putt66937842putt
quest144121322quest
quey164616472quey
quiet144530732quiet
quit136136512quit
ret35982832_ret
rue35549262rue_
rued55729792rued
ruer46127562ruer
rues46044482rues
runt46647992runt
rust45544912rust
rut35560522ru_t
set36681252_set
stet45947322stet
sue35651462sue_
sued56537932sued
suer45334032suer
sues46247652sues
suets55126102suets
suety85318492suety
suit45649872suit
tet39274992_tet
tret46653532tret
tuft76929512tuft
tut36758092tu_t
ut28647032_u_t
ute35335882_ute
vet65958522_vet
weet75254152weet
wet65966622_wet
whet105133782whet
yet66960692_yet
yurt76435042yurt

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298722390.84335435.3
3Display Results2392390.0603983.3
 (SQL Overall)1786912391.186150666.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.