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

289 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
actress94853(None) 
actressy1342601actressy
access1037672ac_cess
acres76327762ac_re_s
across8312642ac_ross
actresses1137932actresses
address956102address
aggress935592aggress
ancress978612ancress
antres65021002antre_s
aptness9268572aptness
artless73712512artless
caress85720262_caress
cateress102311612cateress
cress75022832_c_ress
mattress1036532mattress
stress66616672_stress
tactless10288462tactless
tress55423162__tress
victress1344522victress
votress1035482votress
waitress1135222waitress
abbess10509773a_bbess
abscess1133903abscess
acarids105312243acarids
acarus8312193acar_us
accrete1137843accrete
accretes1238113accretes
accrues1135323accrues
accuses114112193accuses
acerbest1245453acerbest
acerose9310893acerose
acerous9513333acerous
aces67645093ac__e_s
aches106132293ac_he_s
achiest12315183achiest
achiness1339703achiness
acidness1136723acidness
ackees124914573ac_kees
acmes96020653ac_me_s
acnes75922623ac_ne_s
acorns85013013acor_ns
acquest1837173acquest
acquests1944643acquests
acre67330773ac_re__
acred87126353ac_re_d
acted88521733act_e_d
actings104512463actings
actins86321103act_ins
actions94218513actions
actives12311523actives
actorish1349433actorish
actors81016763act_ors
acts66929863act___s
aculeus937513aculeus
acumens1136953acumens
acuteness1145863acuteness
acutes83917723acute_s
acutest94410603acutest
addrest958623addrest
adorers84411723adorers
adores74420713adore_s
adultress1042943adultress
aethers103614943aethers
afresh1255503a_fresh
afters94717073aft_ers
ageless8310343ageless
agrees74915323a_grees
aidless83612073aidless
aigrets82810533aigrets
aimless93610813aimless
airers64922313a_irers
airest63825263a_irest
airless73712043airless
alterers82512493alterers
alters64924223alt_ers
altheas1038223altheas
amtracs1198883amtracs
ancestress1243263ancestress
anchoress1445243anchoress
antes56334323ant_e_s
anthems12309423anthems
anthers103715203anthers
antheses11311473antheses
anthesis11312503anthesis
antipress1146413antipress
antlers74014743antlers
antre55224523antre__
antrums969173antrums
anureses837973anureses
anuresis846963anuresis
apres75426403a_pre_s
aptest82917513apt_est
arbitress1143853arbitress
archness1337513archness
areas55935773a__reas
ares45871023a__re_s
armless9369943armless
armrest9310163armrest
armrests1055383armrests
arrest63722633a_rrest
arrests73312683a_rrests
arses55733873a__rses
artels66216233art_els
artiest73121993artiest
artiness81615403artiness
ashless10318453ashless
assess65710463a_ssess
asters65631603ast_ers
astrals75515243astrals
ates45047923a_t_e_s
atresia7310223a_tresia
atresias839473a_tresias
atresic9310003a_tresic
attest62618613a_ttest
attests7278813a_ttests
attires72312953attire_s
attrits7310613attrits
aures55137093a_ure_s
aureus65314883a_ureus
authoress1245173authoress
aviatress1242433aviatress
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
azures15510183azure_s
backless162910633backless
backrest1639393backrest
backrests1744983backrests
bractless1335543bractless
buttress1035883buttress
cactuses1237933cactuses
cadres94017933cadre_s
capless114312763capless
carers85133963_carers
cares77369183_care_s
carets85330773_carets
carless95118493carless
carrels95117303carrels
carses85233653_carses
cartels94618123cartels
carters95327253carters
cartes86239473carte_s
caterers102814403caterers
caters85336503cat_ers
cates75951883cat_e_s
ceres75540013_cere_s
cereus85215523_cereus
cess65326053_c__ess
chess105016923_c_hess
cires74932913_cire_s
corers85231073_corers
cores76361853_core_s
corses84433463_corses
crass76328043_c_rass
creds85418773_c_reds
cressy11439113_c_ressy
crest74632693_c_rest
crests85218703_c_rests
crews105917493_c_rews
cross75124503_c_ross
curers84923193_curers
cures75645433_cure_s
curets84922343_curets
curses85328273_curses
cypress1434653cypress
daftness1235533daftness
depress10239873depress
digress938323digress
distress9311713distress
dress65319833__dress
ductless11196313ductless
duress74712063_duress
ectases92911673ectases
editress944933editress
egress73310433_egress
eldress835003eldress
electress1146093electress
empress1138163empress
entrees71813773entrees
exactness1843623exactness
express1637493express
faceless13269173faceless
factures13129023facture_s
fastness11238763fastness
fatless103212203fatless
fatness103311293fatness
fitness10299393fitness
fortress1136753fortress
gastness9278473gastness
gastreas957253gastreas
gutless82610713gutless
haltless11308443haltless
hatless103813443hatless
hatreds11307813hatreds
heiress1036813heiress
hitless103211193hitless
hotness1038613hotness
hotpress1344303hotpress
huntress1144833huntress
iceless9219963iceless
iciness938863iciness
icterus936073icterus
ictuses938303ictuses
impress1137773impress
ingress838653ingress
laceless10239853laceless
laciness102112553laciness
lactases1038513lactases
lactoses1039813lactoses
litres65220393litre_s
machrees1545503machrees
mastless102610023mastless
matless93014043matless
matrass939403matrass
matres84522233matre_s
mattrass1045863mattrass
mayoress1344383mayoress
metres85121563metre_s
mistress10310703mistress
mitres83922073mitre_s
nacres85614453nac_re_s
netless739863netless
nitres65519333nitre_s
ochres113510833ochre_s
octets839403oct_ets
octrois938333octrois
ogress7529503_ogress
oppress1135993oppress
oratress834553oratress
outdress9137323outdress
outpress10118183outpress
packness1636933packness
pantdress1243363pantdress
pastless102411203pastless
pastness102510503pastness
patness92912283patness
peeress939503peeress
petrels9279373petrels
portress1038323portress
press75425953__press
raciness102413453raciness
raptness1046733raptness
redress82511873redress
regress82711453regress
repress92712683repress
restress82511773restress
saltless8259343saltless
saltness82610243saltness
scarers94618503scarers
scares85033003scare_s
scarless10189053scarless
scorers94115313scorers
scores84725923score_s
screes85023963sc_rees
screws115513883sc_rews
seeress7311573seeress
strass67117223_strass
streps86218063_streps
strews96817093_strews
tacitness1134873tacitness
tackless14419483tackless
tartness82210133tartness
tautness8217183tautness
tigress836093tigress
titres64718933titre_s
traitress944403traitress
trass56226473__trass
trees55835763__trees
treks96016853__treks
tres46542903__tre_s
tressy9448553__tressy
trets55928023__trets
trews86118893__trews
treys85018213__treys
truss54916923__truss
tutoress845093tutoress
undress838893undress
unstress837373unstress
untruss736553untruss
vastness11257293vastness
votaress1144223votaress
wardress12256163wardress
wartless11279923wartless
wastrels1136203wastrels
wattless11268723wattless
wetness10277723wetness
witless103310983witless
witness103010013witness

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272898.34316064.6
3Display Results2892890.2501156.0
 (SQL Overall)1786912898.74920424.2
 
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.