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

265 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
aroynt931289(None) 
aroint6328151aroint
aroynts1036631aroynts
amount8414482amount
anoint6423632anoint
ardent73022612ardent
argent74023662argent
aroints7313132aroints
around72712412around
aroynted1244522aroynted
arpent84822092arpent
arrant6623252arrant
front85029222fro_nt
groyne1037212groyne
abeyant1248083abeyant
aboon74918703aboon_
abort76133583abo_rt
abound9239863abound
about75229083abo_ut
absent84016993absent
accent105116263accent
account11109043account
acorn75616623acorn_
acorns85013013acorns
acrobat11411813acrobat
acrodont1148123acrodont
acronym1445673acronym
adjoint15108283adjoint
adopt81219743ado_pt
adorn64917093adorn_
adorns74212613adorns
adown95611663adown_
adroit7518793adro_it
advent102613753advent
aeon45634613aeo_n_
aeons57624653aeo_ns
aerobat9514473aerobat
aerodyne1244193aerodyne
aerosat7417183aerosat
affront1357963affro_nt
afoot8420113afo_ot
agent65829643a_gent
agon56531883ago_n_
agone65924553ago_ne
agons66423783ago_ns
agony96415653ago_ny
agorot7415003agorot
aground9216183aground
ahoy101919183ahoy__
alant55742293a_lant
aliyot93611713aliyot
alkyne13436863alkyne
aloft8423433alo_ft
aloin55227423aloin_
aloins65022203aloins
alone55732963alo_ne
along65419493alo_ng
amboyna1443683amboyna
ament76036543a_ment
among85813303amo_ng
amort75832203amo_rt
amounts937043amounts
anent54931843a_nent
anodyne1144163anodyne
anoints7311063anoints
anon46134853ano_n_
anonym1136383anonym
ant37270793a___nt
anyon85615223anyon_
anyone94612733anyone
anyons94513503anyons
aorist64827873aorist
aport75432173apo_rt
appoint11612483appoint
apron7318833apro_n_
aprons8316993apro_ns
arcana8912583arcana
arcane81216743arcane
arcing95819643arcing
arena55323813ar_ena
arene55329413ar_ene
argents84014853argents
argon65520593argon_
argons75018203argons
argot67728653ar_got
argyle1066063argyle
argyll1033643argyll
arhat8327093ar_hat
aright103817663aright
armet76739453ar_met
arming94719803arming
armlet84118193armlet
armpit10811093armpit
army96624183army__
aroid65428343aro_id
aroids75118223aroids
arointed939003arointed
aroma71220143aro_ma
aromas81018613aromas
arose55832083aro_se
arouse65019983arouse
aroynting1344633aroynting
arpen74418043arpen_
arpens84814823arpens
arpents93613083arpents
arrest63722633arrest
arrogant949153arrogant
arroyo936963arroy_o
arroyos1036533arroyos
arseno6318913arseno
arsine64021043arsine
arsino64113513arsino
arson55118833arson_
arsons63917213arsons
art38679143ar___t
artist64125543artist
arty77531313arty__
aryl75922343ar_y_l
aryls87015813ar_yls
ascent84519653ascent
askant10412713askant
aslant6317753aslant
assent65119953assent
atone56527983ato_ne
atony87218853ato_ny
attent62818323attent
aunt46553653a__unt
avant86224663a_vant
avaunt959603avaunt
avocet11412683avocet
avoset9315673avoset
axon115524303axo_n_
axone125918473axo_ne
axons125517933axo_ns
azon135725053azo_n_
azons146518253azo_ns
baron78131243baro_n_
baronet91022203baronet
barong96015823baro_ng
baronne938263baronne
barons85025383baro_ns
barony115915303baro_ny
baryon111211613baryon_
baryons121010473baryons
biont7727163bio_nt
brant74742173br_ant
brent75734133br_ent
bronc91714343bro_nc
brown105619533brown_
browns116415633browns
browny144510043browny
brunt75728753br_unt
bryony1435833bryony
buoyant1246263buoyant
count74932053_count
croft105622683cro_ft
crone75231333cro_ne
crony105918673cro_ny
croon75522783croon_
croons85418423croons
crown105620083crown_
crownet123714113crownet
crowns115615113crowns
crypt123715233cr_ypt
droit65127123dro_it
drone65324983dro_ne
dropt86924433dro_pt
drown95515823drown_
drownd11478313drownd
drowns105612333drowns
erodent8313823erodent
errant6618733errant
font77143753_fo_nt
forint9325023forint
fount84727033_fount
frond95316343fro_nd
frons86124043fro_ns
fronts94415793fro_nts
frost84727833fro_st
frown115415973frown_
frowns126011393frowns
frowst125512073frowst
gardant9314463gardant
garment10315233garment
grant64840023gr_ant
groan65618423groan_
groans74815063groans
groat65531973gro_at
groin65521083groin_
groins73917203groins
grot55942053gro__t
ground82310273ground
grout65330423gro_ut
grown95317353grown_
groynes1137823groynes
grunt65523543gr_unt
iron46728463iro_n_
irone55126363iro_ne
irons55324133iro_ns
irony85015903iro_ny
joint125227723_joint
krona93611793kro_na
krone94018733kro_ne
kroon94514483kroon_
krooni10397183krooni
kroons103711243kroons
larynx1632853lar_ynx
margent10316693margent
maroon83118203maroon_
maroons92615553maroons
mount74128063_mount
orient6322533orient
parent83230423par_ent
paronym1437503paronym
point75338733_point
print74837463pr_int
probit103218353probit
profit113016273profit
projet15315183projet
prompt12313013prompt
prone75332623pro_ne
prong85218113pro_ng
pronto8313993pro_nto
prosit85124593prosit
prost75434103pro_st
rant45864683_r_ant
rayon83815703rayon_
rayons94113343rayons
rent46661243_r_ent
riant55833153_riant
roan47234203_roan_
roans54926443_roans
roast56230143_roast
robot7325973_robot
rodent7519243_rodent
roost55730933_roost
root45655923_ro_ot
roset55945243_roset
rot37282953_ro__t
round64318433_round
roust55532063_roust
rout46153283_ro_ut
royal85014703_royal
runt46647993_r_unt
rynd86414103_r_ynd
ryot75528563_r_yot
sarment9318763sarment
sarong73914873saro_ng
tarot55943933taro__t
trona54118953tro_na
trone55131863tro_ne
trot46351313tro__t
trout57332573tro_ut
troy77429683troy__
troys86418613troy_s
truant6315783truant
tryout9410753tryout
tryst84716223tr_yst
urgent73816043urgent
variant10316803variant
varment12313243varment
varmint12311683varmint
warrant10614243warrant
wont75842503_wo_nt
wrong94712323wro_ng

Search took 7 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.390458182.1
2DLD Change Limit1127162656.08018538.8
3Display Results2652650.0932849.5
 (SQL Overall)1786912656.56327227.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.