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

342 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
use3683516(None) 
fuse76429991fuse
muse67136031muse
ose38147341ose
ruse45938931ruse
sue35651461sue
uke75727291uke
us26937431us_
used55722821used
user45023001user
uses44931111uses
ute35335881ute
abuse77119562abuse
ace59656832ace
ae212590292_ae
age47154332age
ale36572342ale
amuse75920832amuse
ane37866942ane
ape57251182ape
apse67725382apse
are37874572are
arse46539272arse
as211083072as_
asea46327182asea
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
ate37059242ate
ave67748702ave
awe67746622awe
axe108239492axe
aye67151762aye
base64847022base
be47948942_be
bee56262402bee
bes56557432bes
bise66437092bise
bouse75931852bouse
burse75527252burse
bus56950972bus_
bused85624492bused
buses75936012buses
bush96630712bush
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
bute66739672bute
bye86134592bye
case65848082case
cause75225352cause
cee55952702cee
cruse75726102cruse
cube85830212cube
cue57544182cue
cues65438982cues
cuke105824982cuke
cure66149122cure
curse75829142curse
cusec94614902cusec
cusk105521632cusk
cusp86021062cusp
cuss65430612cuss
cute66440452cute
de37049542_de
dee47665822dee
die46759652die
doe47361952doe
dose56442432dose
douse66329722douse
druse64817662druse
duce76933502duce
dude65629662dude
due45249862due
dues56045502dues
duke95628102duke
dulse65415042dulse
dune56137582dune
dupe76630602dupe
dure56341812dure
dusk95724152dusk
dust57142532dust
dye75334842dye
ease45042332ease
eke75630092eke
else45923082else
eme55837182eme
ere36352772ere
es29048222es_
eses45336102eses
esne47018792esne
ess36030882ess
eve66331162eve
ewe66630982ewe
eye65539772eye
fe57944742_fe
fee66862012fee
fes66551672fes
fie67152442fie
foe66350812foe
fume96727632fume
fused94820442fused
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fuss76027932fuss
fuze166422372fuze
gae46457702gae
gee45359202gee
gie47149542gie
gude65423332gude
guise64717712guise
gush85424002gush
gust55240702gust
hae67364002hae
he58151952_he
hes66654202hes
hie67652702hie
hoe67562722hoe
hose76547242hose
house89131422house
hue66642302hue
hues75235232hues
huge86321652huge
hush105224112hush
husk116021952husk
ice56737242ice
ire36943172ire
is27048212is_
isle45121702isle
ism56322382ism
jee106648642jee
joe106642352joe
jube136322782jube
juke154721662juke
jupe134921002jupe
jus106930222jus_
just115433342just
jute115327892jute
kae76744542kae
kue76631862kue
kues86426772kues
kune85424572kune
kye107327272kye
lase46148512lase
lee36068142lee
les35663072les
lie38264522lie
lose45144582lose
louse56131012louse
lube64731562lube
luce65132572luce
lude55331642lude
lues45943552lues
luge55531642luge
lune47140492lune
lure45142462lure
lush75327692lush
lust47442602lust
lute46341012lute
luxe115222692luxe
lye66533412lye
lyse76320592lyse
mae57659102mae
me47748332_me
mise66043572mise
mouse77133002mouse
mule65236972mule
mure65941332mure
mus55946752mus_
mused85524582mused
muser76024122muser
muses75134302muses
mush94929122mush
musk104526192musk
muss64933762muss
must65145442must
mute65136872mute
nae35952742nae
ne27045102_ne
nee36657782nee
nose46739362nose
nude56626272nude
nuke85920752nuke
nurse54420122nurse
nus37939392nus_
obe56638642obe
ode47446582ode
oe28473062_oe
oes35866192oes
oke75839482oke
ole37155212ole
one37050912one
ope56845242ope
ore36661832ore
os211359882os_
oses46641512oses
ousel55222402ousel
oust46747442oust
owe67041032owe
owse76321622owse
pase65346862pase
pause75021832pause
pe47649032_pe
pee56066512pee
pes57259782pes
pie55457402pie
pose66441732pose
psi56621622psi
pst57932512pst
puce85127882puce
puke105025462puke
pule65040952pule
pulse74219972pulse
pure65543332pure
purse76028892purse
pus55547842pus_
puses75532202puses
push95526622push
puss64830132puss
pye86432502pye
rase46149982rase
re26153742_re
ree37974072ree
res35565042res
reuse56025362reuse
rise45945232rise
roe36861072roe
rose46148902rose
rouse56634702rouse
rube65532012rube
rude55632782rude
rue35549262rue
rues46044482rues
rule49938422rule
rune45236292rune
ruses56136582ruses
rush76628182rush
rusk85823312rusk
rust45544912rust
rye66032542rye
sae38365182sae
sea36161292_sea
sec55945322_sec
see35772262see
seg45544882_seg
sei36048932_sei
sel38253322_sel
sen36058522_sen
ser36752402_ser
set36681252_set
sew66247262_sew
sex107043222_sex
sh56828522_sh
she66837692she
si29149572_si
so28855442_so
souse56530772souse
sub55445552sub
sued56537932sued
suer45334032suer
sues46247652sues
suet46754822suet
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
supe65932762supe
suq126228992suq
sure45447412sure
suss45229302suss
tae38267052tae
tee38366872tee
the67436052the
tie36557532tie
toe310166852toe
touse55430672touse
tsk75814732tsk
tube65828662tube
tule45735872tule
tune45635862tune
tush74523902tush
tusk85621632tusk
tye65837442tye
udo49027302udo
ugh76520682ugh
uh57429852u_h
ukase9428492ukase
ukes86122812ukes
ulu36028702ulu
um47338832u_m
umm711921262umm
ump76130442ump
un28341132u_n
unbe65319272unbe
unde55825482unde
uns35936752uns
unset54532432unset
unsew83912692unsew
unsex123512632unsex
up47832822u_p
upo58925862upo
ups55629052ups
upset73222592upset
urase54624682urase
urb55731102urb
urd46427042urd
urea46528052urea
urge54722412urge
urn35731462urn
urp56426392urp
ursa44116902ursa
ursae55214452ursae
usage6410212usage
users55817572users
usher84517762usher
usnea539392usnea
usque14137732usque
ut28647032u_t
uta37425582uta
utes45930882utes
uts35534372uts
uvea74712652uvea
vase75629652vase
vee65750182vee
vie65447632vie
vise75632672vise
voe67739052voe
wae67556952wae
we57043452_we
wee66760812wee
wise75737342wise
woe66651242woe
wuss75219332wuss
wye96331972wye
ye57650062_ye
yes66250612yes
youse85322232youse
yule75725142yule
zee126143232zee

Search took 1 second 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 Filter178691140840.0602978183.3
2DLD Change Limit140843420.37637457.4
3Display Results3423420.0635428.6
 (SQL Overall)1786913420.499358098.2
 
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.