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

300 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
cute6644045(None) 
acute74720361acute
bute66739671bute
cate66254591cate
cete64934781cete
chute104316461chute
cite65640341cite
cote66648731cote
cube85830211cube
cue57544181cu_e
cuke105824981cuke
cure66149121cure
cut57957661cut_
cuter74728221cuter
cutes79438311cutes
cutey105819791cutey
cutie76925921cutie
cuts65841151cuts
jute115327891jute
lute46341011lute
mute65136871mute
scute75520941scute
ute35335881_ute
acuate8315632acuate
acuter84412862acuter
acutes83917722acutes
ante46538902ante
ate37059242_ate
auto47432082auto
bate66552422bate
bite66546992bite
brute75321782brute
but55963022but_
buteo75419892buteo
butes714535872butes
butle75023102butle
buts67247692buts
butt65143742butt
butte74924292butte
byte96521812byte
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
cane66653112cane
cape87242782cape
care66968372care
carte75940422carte
case65848082case
caste75932362caste
cat58282342cat_
cater74840702cater
cates75951872cates
cats66356342cats
cause75225352cause
cave95941262cave
cede74928762cede
cee55952702c_ee
cepe84926652cepe
cere66741472cere
cetes75731102cetes
chuted124611842chuted
chutes114615762chutes
cine66242942cine
cire65836372cire
cited84421952cited
citer74827322citer
cites74435582cites
city95122622city
clue65324532clue
code77347732code
coke107038382coke
cole66956112cole
come87547702come
comte96125472comte
cone67256962cone
conte76633202conte
cope86847382cope
core67263112core
cot510483222cot_
coted85033852coted
cotes76347842cotes
cots68054842cots
coude85022632coude
coupe96023482coupe
couter84930202couter
couth106122482couth
cove95837072cove
crate76537402crate
croute84617272croute
crude86018572crude
cruet74831842cruet
cruse75726102cruse
cub76940942cu_b
cubeb115814652cubeb
cubed105519702cubed
cuber95222532cuber
cubes95028162cubes
cubs85832382cubs
cud67937452cu_d
cuds76730472cuds
cued76329562cued
cues65438982cues
cuff125327992cuff
cuif96529132cuif
cukes115422092cukes
culet76040342culet
culex144613932culex
cull65929642cull
culm85822382culm
cult66541152cult
culti76317252culti
cults75022552cults
cum76440162cu_m
cunt66243672cunt
cunts76125122cunts
cup76738242cu_p
cupel9514302cupel
cups85430822cups
cur56841982cu_r
curate85226242curate
curb86732222curb
curd77634982curd
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curf97538782curf
curie74533032curie
curite85222942curite
curl66035052curl
curn66731882curn
curr65429652curr
curs65645542curs
curse75829142curse
curt67051712curt
curter85320072curter
curve104920022curve
cusec94614902cusec
cusk105521632cusk
cusp86021062cusp
cuss65430612cuss
cutch125116192cutch
cutely115312802cutely
cutest85820142cutest
cutesy114810732cutesy
cuteys11569972cuteys
cuties84927362cuties
cutin75022772cutin
cutis77723752cutis
cutler84718032cutler
cutlet84924362cutlet
cutter84520992cutter
cuttle84113892cuttle
cutty105417222cutty
cutup9410092cutup
cuvee10316142cuvee
cyme119420372cyme
date56443322date
dite55547552dite
dote55442882dote
duce76933502duce
dude65629662dude
due45249862du_e
duet56446262duet
duke95628102duke
dune56137582dune
dupe76630602dupe
dure56341812dure
duty85321452duty
elute54822572elute
fate75444282fate
fete75734922fete
flute86823752flute
fume96727632fume
fuse76429992fuse
futz167823802futz
fuze166422372fuze
gate55746572gate
gite55438612gite
glute66020902glute
gude65423332gude
gut46753852gut_
guts56637252guts
hate78450172hate
haute89521612haute
hue66642302hu_e
huge86321652huge
hut66457292hut_
huts76737442huts
hyte109018942hyte
jete115927252jete
jube136322782jube
juke154721662juke
jupe134921002jupe
jut105944012jut_
jutes125125132jutes
juts115930162juts
kite85338232kite
kue76631862ku_e
kune85424572kune
kyte117017762kyte
late47560482late
lite47054542lite
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lune47140492lune
lure45142462lure
lutea54819072lutea
luted64826142luted
lutes55836662lutes
lutz136826322lutz
luxe115222692luxe
mate65154212mate
mete64438132mete
mite66249402mite
mote67048082mote
mule65236972mule
mure65941332mure
muse67136032muse
mut58357182mut_
muted85023382muted
muter74525542muter
mutes75033782mutes
muts64839982muts
mutt65739402mutt
nite45943582nite
note46239962note
nude56626272nude
nuke85920752nuke
nut36651962nut_
nuts45032672nuts
out38072152out_
outed65429062outed
outer55633302outer
outre53922192outre
outs45746962outs
pate65350462pate
puce85127882puce
puke105025462puke
pule65040952pule
pure65543332pure
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
quate144521412quate
quite144621462quite
quote143714772quote
rate45458762rate
rete44944132rete
rite45849452rite
rote46249022rote
route55132072route
rube65532012rube
rude55632782rude
rue35549262ru_e
rule49938422rule
rune45236292rune
ruse45938932ruse
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
sate45556102sate
saute55028082saute
scut65835542scut_
scuta75815752scuta
scutes85219192scutes
scuts74522522scuts
shute84520342shute
site47052412site
sue35651462su_e
suet46754822suet
suite54829562suite
supe65932762supe
sure45447412sure
tate44748602tate
tote46643672tote
tube65828662tube
tule45735872tule
tune45635862tune
tut36758092tut_
tutee5423522tutee
tuts45838452tuts
tutu48423172tutu
uke75727292_uke
uncute82912132uncute
use36835162_use
ut28647032_ut_
uta37425582_uta
utes45930882_utes
uts35534372_uts
vote74728622vote
wite75443272wite
wyte106018642wyte
yule75725142yule
yutz167519882yutz

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.1401276364.3
2DLD Change Limit298723000.86034734.9
3Display Results3003000.0605000.0
 (SQL Overall)1786913001.060168576.4
 
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.