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

307 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
adroit751879(None) 
droit65127121_droit
adit56443652ad__it
adjoin14107292adjoin
adjoint15108282adjoint
admit8319492ad_mit
adopt81219742ad_opt
adrift10313112adrift
adroiter946192adroiter
adroitly1243362adroitly
afrit8323172afr_it
android9311512android
aroid65428342a_roid
aroint6328152a_roint
dacoit9415452dacoit
dakoit11310352dakoit
doit56347852_d_oit
droid74218542_droid
droits74314312_droits
dropt86924432_dropt
abbot9318453abbo_t
aboil72217543a_boil
abort76133583a_bort
about75229083a_bout
abri65522213abr_i_
abris75722603abr_is
abroad9310943abroad
abrosia939273abrosia
abrupt1039943abrupt
abvolt11169833abvolt
acaroid103512313acaroid
accost101112263accost
acquit17610323acquit
acrid86920103acr_id
acrobat11411813acrobat
acrolith1348453acrolith
acromia1139963acromia
acronic112814693acronic
across8312643across
acrotic112515543acrotic
adagio847673adagio
adapt81218553ad_apt
addict10711203addict
addrest958633addrest
adduct1087373adduct
adenoid959253adenoid
adept81219643ad_ept
adhibit1345343adhibit
adios65822863adio_s
adipic1137263adipic
adits66523713ad__its
adjoins1585983adjoins
adjoints16103873adjoints
adjust1447183adjust
admits9411413ad_mits
admix1557733ad_mix
admixt1637333admixt
adnoun757033adnoun
ado49146873ad_o__
adobe84814713ad_obe
adobo84711593ad_obo
adonis7314063adonis
adopts998083ad_opts
adore65723673ad_ore
adored84714243adored
adorer74713453adorer
adores74420723adores
adoring9412523adoring
adorn64917093ad_orn
adorns74212613adorns
ados57633513ad_o_s
adown95611663ad_own
adoze155713833ad_oze
adroitest1044763adroitest
adsorb946953adsorb
adult63520653ad_ult
adust64117453ad_ust
advect12309123advect
advent102613753advent
advert103215783advert
aerie54634603aer_ie
aero45435343aero__
aerobat9514473aerobat
aerobe8412403aerobe
aerobia939463aerobia
aerobic11310213aerobic
aerolite8315053aerolite
aerolith1149833aerolith
aerosat7417183aerosat
affront1357963affront
afloat9315153afloat
afoot8420113a_foot
afraid1049723afraid
afreet9315153afreet
afrits9311903afr_its
agorot7415003agorot
agria65517143agr_ia
airboat9512133airboat
airest63825263airest
airfoil1044463airfoil
airlift1048583airlift
airport9511383airport
airpost939243airpost
airt45757783air__t
ait38093903a___it
albeit8314343albeit
aldrin7311243aldr_in
algoid83011473algoid
alit46155693a__lit
allot54933873allo_t
almost81014433almost
aloft8423433a_loft
aloin55227423a_loin
altoist7313393altoist
ambit94223713a_mbit
ambroid1238883ambroid
amorist9317643amorist
amort75832203a_mort
amrita8411133amr_ita
andro6314163andro__
androids1047753androids
andros7313303andro_s
aneroid8314003aneroid
anoint6423633a_noint
aorist64827873aorist
aortic8316613aortic
aporia8315863aporia
aport75432173a_port
appoint11612483appoint
apron7318833apro_n
aprons8316993aprons
aprotic112715243aprotic
ardent73022613ardent
ardor64617863ardo_r
ardors74416873ardors
ardour74110903ardour
areic73219393a_reic
argil65116883a_rgil
argot67728653a_rgot
arhat8327093a_rhat
aria46245423a_r_ia
arid57642713a_r_id
aril45843023a_r_il
armet76739453a_rmet
armpit10811093armpit
aroids75118223a_roids
aroints7313133a_roints
aroma71220143a_roma
arose55832083a_rose
aroynt9312893a_roynt
arrant6623253arrant
arrest63722633arrest
arris56824683a_rris
arroba898663arroba
arrow83414883arro_w
arrows92813483arrows
arrowy12288273arrowy
arroyo936963arroyo
arsis55722423a_rsis
art38679143a_r__t
artist64125543a_rtist
ascot76522513asco_t
askoi9507803askoi_
assoil688543assoil
assort64916383assort
atria56022343atr_ia
atrip75315753atr_ip
atrocity1347213atrocity
atropin9311583atropin
attrit6315753attrit
audit62527883a_udit
aurei54821863aurei_
auric74521733aur_ic
auris55331533aur_is
aurist65027253aurist
aurora6411763aurora
aurous64119263aurous
avoid95516683a_void
await85524493a_wait
azoic162912063a_zoic
brit66350153_br_it
broil74918223_broil
bruit76126723_bruit
carrot8423123carro_t
crit65743713_cr_it
croft105622683_croft
dacoits1079073dacoits
dacoity1366183dacoity
dakoits1245293dakoits
dakoity1543423dakoity
dammit11311133dammit
daric85623113dar_ic
darkie113714013darkie
dart55857873dar__t
davit93424593_davit
daylit10512493daylit
debit85727853_debit
demit84832303_demit
dhoti9310123_dhoti
digit73825273_digit
dit47071333_d__it
dixit134420593_dixit
doat56947673_d_oat
doits66223673_d_oits
dolt56649423_d_olt
dost57248353_d_ost
dot47573183_d_o_t
draft95526683_draft
drail65020973_drail
drain65222893_drain
drat56247833_dr_at
drest65530343_drest
drib76823263_dr_ib
drift95722843_drift
drip76223953_dr_ip
dript86923873_dript
droids84712583_droids
droll65415403_droll
drone65324983_drone
drool65416103_drool
droop85814823_droop
drop75324403_dro_p
drops85719503_drops
dross65418093_dross
drouk1039433_drouk
drouth104410103_drouth
drove95518063_drove
drown95515823_drown
druid74111323_druid
duit56241583_d_uit
edit54934863ed__it
enroot6615993enroot
fadeout11410193fadeout
forrit91916623forrit
frit77044473_fr_it
front85029223_front
frost84727833_frost
fruit85122223_fruit
gadoid9310463gad_oid
gadroon938173gadroon
griot65328413_griot
grit55247243_gr_it
groat65531973_groat
groin65521083_groin
grot55942053_gro_t
grout65330423_grout
hadron102913753hadro_n
hadronic1447953hadronic
hadrons113314303hadrons
heriot9422343heriot
hermit11519443hermit
heroic113516923heroic
heroin94420593heroin
hydroid1539713hydroid
idiot6718863idio_t
introit7414533introit
krait94726773_krait
labroid1038823labroid
ladron73413323ladro_n
ladrone83611873ladrone
ladrons83813193ladrons
lirot5430033liro_t
madrona10288703madrona
madrone102812663madrone
madrono10288743madrono
madwort13611363madwort
maladroit1255223maladroit
merit7339183mer_it
orbit73622063_orbit
padri85815173padr_i_
padrone102512073padrone
padroni10278613padroni
parrot8320663parro_t
patriot9314533patriot
permit10321683permit
probit103218353_probit
profit113016273_profit
prosit85124593_prosit
prost75434103_prost
quoit143819863_quoit
redroot8312903redroot
riot45947213__riot
roil46235293__roil
root45655923__root
rot37282953__ro_t
roti46332933__roti
rout46153283__rout
sprit76736403spr_it
sprout8419403sprout
strait64025893strait
taproot9412673taproot
tarot55943933taro_t
territ63421373territ
throat94819753throat
toit46353063__toit
toroid7416013toroid
torot56139943toro_t
trait56940843_trait
trois57226093_trois
trot46351313_tro_t
trout57332573_trout
turbit8715113turbit
unroot6315553unroot
uproot8314123uproot
viroid10411523viroid
worrit92313313worrit
writ75537913_wr_it

Search took 5 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.1261418182.5
2DLD Change Limit1127163074.75023729.7
3Display Results3073070.0933301.1
 (SQL Overall)1786913074.96935961.2
 
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.