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

199 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
scut6583554(None) 
cut57957661_cut
scat65848371scat
scot66242601scot
scout75031451scout
scud76221281scud
scum85924521scum
scup84822381scup
scuta75815751scuta
scute75520941scute
scuts74522521scuts
shut76137581shut
slut45040591slut
smut66629781smut
abut66834952abut
act59557842ac_t
acute74720362acute
ascot76522512ascot
ascus75013582ascus
bhut95425712bhut
bout66353292bout
brut66537962brut
but55963022_but
cat58282342_cat
cot510483222_cot
cub76940942_cub
cud67937452_cud
cue57544182_cue
cult66541152_cult
cum76440162_cum
cunt66243672_cunt
cup76738242_cup
cur56841982_cur
curt67051712_curt
cute66440452_cute
cuts65841152_cuts
daut56443562daut
duct75735462duct
echt95722902echt
ecu56828232ecu_
ecus65421462ecus
escot75320082escot
glut56331292glut
gout56646002gout
gut46753852_gut
haut75949732haut
hut66457292_hut
jut105944012_jut
lout45952142lout
maut65448442maut
miscut10614812miscut
mut58357182_mut
nut36651962_nut
out38072152_out
phut96925972phut
pout65752552pout
put55759072_put
recut74729242recut
rout46153282rout
rut35560522_rut
sacbut10811942sacbut
salt45758522salt
sat36288482s_at
sau36356572sau_
saul45836522saul
sault55834962sault
saute55028082saute
scab85926712scab
scad75725762scad
scag76626892scag
scam85932352scam
scan65530452scan
scant79735072scant
scar66434202scar
scart76139772scart
scats75930602scats
scatt76030092scatt
scaup95515992scaup
scaur75814902scaur
scent75831622scent
schuit1139562schuit
schul102510412schul
scoot75729142scoot
scop85925522scop
scots74025902scots
scour75315532scour
scouth115011152scouth
scouts84817942scouts
scow96021422scow
scrub94914202scrub
scrum95418192scrum
scry96017762scry
scuba94211592scuba
scudi85112162scudi
scudo85412212scudo
scuds85116242scuds
scuff133914892scuff
sculk115112462sculk
scull75315762scull
sculp95314842sculp
sculpt104412692sculpt
scums95017422scums
scups95316652scups
scurf104719322scurf
scutch13247082scutch
scutes85219192scutes
scutum1036362scutum
scuzz1537572scuzz
seat47575562seat
sect67443622sect
sent46963012sent
sept65844362sept
set36681252s_et
sett45949052sett
sext117338092sext
shat76456592shat
shit76745932shit
shot76150242shot
shout85433162shout
shul75823152shul
shun75122772shun
shunt85226502shunt
shute84520342shute
shuts85622472shuts
sift710740662sift
silt46558192silt
sit35877752s_it
skat87037892skat
skit85437522skit
skua86113152skua
slat46959022slat
slit46250102slit
slot46049822slot
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
sluts54523982sluts
smit65138402smit
smug75815262smug
smuts75415712smuts
snit46342472snit
snot44745442snot
snout54530632snout
snub65320762snub
snug55218692snug
soft76942822soft
soot45761052soot
sort46264812sort
sot310384292s_ot
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
south85223572south
spat66548522spat
spit65545082spit
spot65540682spot
spout75029632spout
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
spurt77227982spurt
sputa74612962sputa
squat143720142squat
stat47352692stat
stet45947322stet
stot46347322stot
stout57434052stout
strut56030732strut
stub66221842stub
stud56220092stud
stum65526012stum
stun45623452stun
stunt55328172stunt
sturt56028962sturt
sub55445552s_ub
such96424812such
suck106131732suck
sue35651462s_ue
suet46754822suet
suit45649872suit
suk75632972s_uk
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
swat77244442swat
swot75134652swot
swum96416822swum
taut47048962taut
tout46753822tout
tut36758092_tut
uncut73219172uncut
ut28647032__ut

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 Filter178691298720.0762351197.4
2DLD Change Limit298721990.75039829.3
3Display Results1991990.0464326.1
 (SQL Overall)1786911990.872204920.9
 
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.