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

207 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
aunts5522763(None) 
ants47243471a_nts
aunt46553651aunt_
aunty85919811aunty
bunts75729801bunts
cunts76125121cunts
daunts75014081daunts
dunts65828411dunts
haunts95614391haunts
hunts86826171hunts
jaunts137511881jaunts
lunts55826901lunts
punts75828001punts
runts55927631runts
taunts65715661taunts
vaunts95212621vaunts
abets75621672abets
abuts75417072abuts
acnes75922622acnes
acts66929862a_cts
adits66523712adits
adults7299952adults
agents74816292agents
ains46158882ain_s
airts55626342airts
aits46355532a_its
alants67722022alants
alts46639902a_lts
aments85219802aments
amounts937042amounts
anas46649862a_nas
ands57833612a_nds
anes45255932a_nes
anis45746462a_nis
annas55824882annas
ant37270792a_nt_
anta46839582a_nta
antas55432032a_ntas
ante46538902a_nte
antes56334322a_ntes
anti45536362a_nti
antis55033312a_ntis
antsy85712792a_ntsy
anus47131112a_nus
arts49650262a_rts
audits72814112audits
aughts104710242aughts
auks85525262au_ks
auntie64317702auntie
aunties73920072aunties
auntly95211062auntly
auras55932552auras
aures55137092aures
auris55331532auris
auto47432082au_to
autos56523322autos
awns75324432awn_s
bents76033692bents
bints76130182bints
blunts84512892blunts
brunts85215452brunts
bunas75126572bunas
bunds85523542bunds
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunt65850852bunt_
busts75227692busts
buts67247692bu_ts
butts75824252butts
cants77036942cants
cents74730332cents
chaunts1267082chaunts
counts84618272counts
cults75022552cults
cunt66243672cunt_
cuts65841152cu_ts
daunt65929082daunt_
dauts67822242dau_ts
dents65031802dents
dints67431312dints
ducts85319892ducts
duets65323882duets
duits65021882duits
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunt55746872dunt_
dusts65923562dusts
faints94818782faints
faults94513552faults
faunas94013632faunas
fauns84516752faun_s
flaunts1056132flaunts
fonts86124752fonts
founts94313382founts
funds94119252funds
funks125318912funks
funs75235732fun_s
gaults74112782gaults
gaunt65430402gaunt_
gents65729612gents
grunts75511852grunts
gunks104517722gunks
guns55533482gun_s
gusts65722792gusts
guts56637252gu_ts
haints94417582haints
hants86335402hants
haunt85229132haunt_
hents87330742hents
hints87330622hints
hunks125321452hunks
huns76136932hun_s
hunt76445492hunt_
hurts86922822hurts
huts76737442hu_ts
jaunt125025272jaunt_
jaunty16388512jaunty
junks164815972junks
junta123713672junta
juntas134210502juntas
junto125114562junto
juntos134110842juntos
justs124918262justs
juts115930162ju_ts
lints57137192lints
lunas55025012lunas
lunes55337772lunes
lunets66914762lunets
lungs65223882lungs
lunks94822452lunks
lunt46148842lunt_
lusts55022802lusts
maunds9519652maunds
mauts75927192mau_ts
mints76834042mints
mounts84115072mounts
munis75022002munis
muns65535922mun_s
musts75527442musts
muts64839982mu_ts
mutts75120252mutts
nuns45228232nun_s
nuts45032672nu_ts
ousts55225702ousts
outs45746962ou_ts
paints85921832paints
pants76536922pants
pints75936222pints
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punt65747202punt_
punto75121322punto
puntos85915792puntos
punty106021612punty
puts65641752pu_ts
putts75719272putts
quants153614142quants
quints154316562quints
quits144122352quits
rants55935342rants
rents55935182rents
runes55530222runes
rungs611819402rungs
runs46438072run_s
runt46647982runt_
runty86119042runty
rusts55026992rusts
ruts44541492ru_ts
saints65122422saints
saults65816172saults
saunas63915432saunas
shunts95712022shunts
stunts65615252stunts
suets55126102suets
suints64617782suints
suits55028052suits
sunns55017352sunns
suns45841902sun_s
taints64520532taints
taunt55532282taunt_
tauts56125512tau_ts
tents56434212tents
tints56030922tints
tufts85713272tufts
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
tuts45838452tu_ts
units54923432_units
uns35936752_un_s
unto45824282_unto
uts35534372_u_ts
vaults94511672vaults
vaunt85925312vaunt_
vaunty12409062vaunty
vents86125932vents
wants87932212wants
wonts87621542wonts
yurts87216532yurts

Search took 4 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 Filter178691538000.1061685764.2
2DLD Change Limit538002073.12617210.5
3Display Results2072070.0633285.7
 (SQL Overall)1786912073.29554231.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.