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

355 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
astute631076(None) 
actuate9311442actuate
acute74720362a_cute
arbute8311042arbute
assume897562assume
assure6610772assure
astutely1153642astutely
attune637982attune
estate64719762estate
hastate10313912hastate
pasture9311462pasture
salute64418022salute
saute55028082_saute
scute75520942_scute
shute84520342_shute
state56237332_state
stupe75217752_stupe
abate76627843a_bate
abduce1197193abduce
abjure1536733abjure
ablate82219213ablate
abluted10188363abluted
about75229083about_
absolute1044483absolute
abstruse1065513abstruse
abuse77119563a_buse
abut66834953a_but_
abuts75417073a_buts
abutted1056983abutted
abutter957513abutter
accuse103411033accuse
acetate92514753acetate
active11313743active
actual8311023actual
actuated1138743actuated
actuates10310303actuates
acuate8315633acuate
acuter84412863a_cuter
acutes83917723a_cutes
adduce1076453adduce
adjure1435833adjure
adnate72913483adnate
aerate64830553aerate
aesthete1145853aesthete
agate66525143a_gate
agitate8312063agitate
agnate73314873agnate
agouti7388763agouti
agouty10366913agouty
ague55725923a_gu_e
alate55340323a_late
albite8313303albite
allude73910903allude
allure63012943allure
almuce10348213almuce
almude9399933almude
ampule10710613ampule
amputee1148863amputee
amuse75920833a_muse
ansate64517863ansate
antae56828293ant_ae
ante46538903a__nte
antre55224523ant_re
apatite9312963apatite
aplite8316393aplite
apostate1049853apostate
aquae142212713a_quae
arbutes939703arbutes
arcuate9311963arcuate
arete56031353a_rete
argue64818443argu_e
aristate8312123aristate
armure8710133armure
arouse65019983arouse
artiste73813693artiste
ascites9312603ascites
ascot76522513ascot_
ascots85312513ascots
ascus75013583ascu_s
ashore9414613ashore
aside65122083as_ide
aslope839013aslope
aspire8612123aspire
asset55932263asset_
assets65617663assets
assize1538633assize
assuage835683assuage
assumed1065293assumed
assumer965363assumer
assumes967163assumes
assured858373assured
assurer767783assurer
assures7611403assures
astatic9514193astatic
astatine8313533astatine
aster55434893ast_er
astern64815813astern
asters65631603asters
asthma11126563asthma
astilbe945653astilbe
astir55517093ast_ir
astony9510523astony
astound845503astound
astral66919283astral
astray95615543astray
astride8311973astride
ate37059243a___te
atone56527983a_tone
att35454653a_t_t_
attire62412383attire
attrite7311833attrite
attuned835173attuned
attunes737823attunes
augite7312613augite
aurate64426473aurate
austere7312993austere
auto47432083a__uto
autumn836013autumn
autunite856693autunite
aviate9315203aviate
axite125218253a_xite
azote144416343a_zote
azure14911483a_zure
ballute938543ballute
bascule1136573bascule
basque17259083basqu_e
baste74829983bas__te
bastile9313913bastile
battue84311003battu_e
bistate9313813bistate
brute75321783_brute
bute66739673__bute
butte74924293but_te
butut75522913butut_
bututs8409423bututs
capture1138903capture
caseate9314783caseate
casette9310393casette
casque17299273casqu_e
caste75932363cas__te
castle84918963cast_le
castrate10313863castrate
chute104316463_chute
costate94019273costate
costume1157853costume
croute84617273croute
cute66440453__cute
dasyure1153823dasyure
depute94512303depute
dilute72911803dilute
dispute1039083dispute
elute54822573_elute
emeute838533emeute
estated83715573estated
estates74520173estates
esthete1047433esthete
etude63612303_etude
facture12108923facture
flute86823753_flute
future939563future
fytte1138583fyt_te
gestate83614073gestate
gesture839243gesture
glute66020903_glute
haste85927863has__te
haute89521613_haute
impute1038033impute
instate71616473instate
issue559213issu_e
istle52214713ist_le
jute115327893__jute
lactate9312693lactate
latte55426303lat_te
lotte54923853lot_te
lute46341013__lute
masque17249383masqu_e
matte75626843mat_te
mature8313463mature
metate82720533metate
minute83414293minute
mistune9310653mistune
motte75526973mot_te
mutate83017483mutate
mute65136873__mute
mutule8311423mutule
nature6311263nature
notate63217863notate
nutate63017373nutate
obtuse8147483obtuse
oscule838193oscule
outate62923403outate
partite9317133partite
paste74932953pas__te
pastie85525523past_ie
pastime114611973pastime
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
petite84320653petite
posture9313253posture
pustule937683pustule
rapture937383rapture
rasure6311423ras_ure
ratite65022423ratite
refute95515703refute
repute84716093repute
restate73824873restate
retune69121953retune
retuse66617223retuse
rotate63320343rotate
rotte54625933rot_te
route55132073_route
saluted84511703saluted
saluter73512453saluter
salutes73716253salutes
samite83020603samite
sapote8314353sapote
sate45556103_s_ate
satiate7315403satiate
satire63218003satire
saturate8312813saturate
sauce75121653_sauce
sauted74119603_sauted
sautes63924913_sautes
savate9313783savate
scut65835543_scut_
scuta75815753_scuta
scutes85219193_scutes
scuts74522523_scuts
sente56432873_sente
shote85526083_shote
shut76137583_shut_
shuted103913163_shuted
shutes93518213_shutes
shuts85622473_shuts
site47052413_s_ite
situate7410773situate
sixte126216583_sixte
skate94721543_skate
skite95120043_skite
slate55438283_slate
slue45332193_slu_e
slut45040593_slut_
sluts54523983_sluts
smite75224863_smite
smote75820273_smote
smut66629783_smut_
smuts75415713_smuts
solute64016663solute
souse56530773_souse
souter64225923_souter
south85223573_south
spate74731583_spate
spite75430663_spite
spue66025523_spu_e
spume95817313_spume
sputa74612963_sputa
stacte82113913_stacte
stade64825303_stade
stage65330193_stage
stake95927533_stake
stale55637103_stale
stane55933003_stane
stare54440263_stare
stat47352693_stat_
stated75427833_stated
stater64427553_stater
states64337083_states
stats55933363_stats
statue66015323_statue
statute7419323statute
stave85324993_stave
stele55026843_stele
stere55328543_stere
stet45947323_stet_
stets55423913_stets
stile54931573_stile
stime76521793_stime
stipe76523373_stipe
stoae55024263_stoae
stoke94922513_stoke
stole54928813_stole
stone55431183_stone
stope74727243_stope
store56333813_store
stot46347323_stot_
stots54828543_stots
stott56929783_stott
stoure64814943_stoure
stout57434053_stout_
stouten7307333_stouten
stouter74012053_stouter
stouts65019003_stouts
stove85220253_stove
strut56030733_strut_
struts65616803_struts
stub66221843_stu_b
stubs75016073_stubs
stuck114515773_stuck
stud56220093_stu_d
studs64415873_studs
study94411793_study
stuff113817053_stuff
stull54916273_stull
stum65526013_stu_m
stump94616463_stump
stums75320083_stums
stun45623453_stu_n
stung65417153_stung
stunk94616293_stunk
stuns54719493_stuns
stunt55328173_stunt
stunted83010403_stunted
stunts65615253_stunts
stupa74112313_stupa
stupes84116953_stupes
sturt56028963_sturt
sturts63915143_sturts
stutter72911463_stutter
stye76218973_st_ye
style85519363_style
sue35651463_s_u_e
suet46754823_s_uet
suite54829563_suite
supe65932763_s_upe
sure45447413_s_ure
sutta54015333_sutta
suttee63721543_suttee
suture6313203suture
tartufe1064673tartufe
taste55127233tas__te
tate44748603__tate
testate73916233testate
tote46643673__tote
tube65828663__tube
tule45735873__tule
tune45635863__tune
tut36758093__tut_
tutee5423523__tutee
tuts45838453__tuts
tutu48423173__tutu
uncute82912133uncute
unstate71916213unstate
untune62511603untune
upstate91610493upstate
usque14137733usqu_e
ustulate868323ustulate
ute35335883___ute
vastity1336203vastity
vesture10310373vesture
volute93912763volute
wafture1334853wafture
wastage11109253wastage
waste86125053was__te
wastrie101210293wastrie

Search took 6 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127163555.50020493.8
3Display Results3553550.1103227.3
 (SQL Overall)1786913555.76630990.5
 
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.