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

272 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
ancress97861(None) 
access1037672a_ccess
acres76327762a_cre_s
across8312642a_cross
actress948532actress
address956102address
aggress935592aggress
anchoress1445242anchoress
ancresses1138412ancresses
antres65021002antre_s
anureses837972anureses
anuresis846962anuresis
cress75022832__cress
incross937662incross
ingress838652ingress
nacres85614452nacre_s
pancreas1235392pancreas
uncross938192uncross
undress838892undress
abbess10509773a_bbess
abscess1133903abscess
accrete1137843accrete
accretes1238113accretes
accrues1135323accrues
accuses114112193accuses
aces67645093a_c_e_s
aches106132293a_che_s
ackees124914573a_ckees
acmes96020653a_cme_s
acnes75922623a_cne_s
acre67330773a_cre__
acred87126353a_cre_d
actressy1342603actressy
addrest958623addrest
adorers84411723adorers
adores74420713adore_s
afresh1255503a_fresh
ageless8310343ageless
agrees74915323a_grees
aidless83612073aidless
aigrets82810533aigrets
aimless93610813aimless
aircrews13122813aircrews
airers64922313a_irers
airest63825263a_irest
airless73712043airless
anacruses1145513anacruses
anacrusis1143883anacrusis
anadems1036143anadems
anapest9311553anapest
anapests1046613anapests
anarchs1237093anarchs
ancestress1243263ancestress
anchorets1445993anchorets
anchorless1543033anchorless
anchors123912953anchors
anchos114214893anc_hos
anchusa1244333anchusa
anchusas1344753anchusas
ancient9514733ancient
ancients1098973ancients
ancones93116343ancones
andros7313303andr_os
aneles64626293anele_s
anes45255933an__e_s
angels74416173an_gels
angerless1045023angerless
angers75222543an_gers
anglers84014823anglers
angles74426703angle_s
angriest9310253angriest
angriness1036453angriness
animes84719593anime_s
anises64826693anise_s
ankles104818383ankle_s
anklets114310413anklets
ankuses1148203ankuses
anlases72514903anlases
anodes74418753anode_s
anoles64827423anole_s
anoraks1137603anoraks
anorexy1743563anorexy
answers1037043answers
antes56334323an_te_s
anthems12309423anthems
anthers103715203anthers
antheses11311473antheses
anthesis11312493anthesis
antipress1146413antipress
antlers74014743antlers
antre55224523antre__
antrums969173antrums
anurans73810553anurans
anurias7312243anurias
anurous7311553anurous
anuses66218773anuse_s
apres75426403a_pre_s
aptness9268573aptness
archers124414573archers
arches114822043arche_s
archness1337513archness
arcuses94814693arcuses
areas55935773a__reas
ares45871023a__re_s
armless9369943armless
armrest9310163armrest
armrests1055373armrests
arrest63722633a_rrest
arrests73312683a_rrests
arses55733873a__rses
artless73712513artless
asceses938623asc_eses
ascesis938373asc_esis
ashless10318453ashless
assess65710463a_ssess
aures55137093a_ure_s
aureus65314883a_ureus
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
azures15510183azure_s
cancels114113313canc_els
cancers114018583canc_ers
canoness1039393canoness
caress85720263_caress
cateress102311603cateress
cess65326053__c_ess
chancres15429363chancre_s
chess105016923__chess
congress1138073congress
crass76328043__crass
creds85418773__creds
cressy11439113__cressy
crest74632693__crest
crests85218703__crests
crews105917493__crews
cross75124503__cross
cypress1434653cypress
dancers103413093danc_ers
dances95120653danc_e_s
dankness13256693dankness
decrees102513123decrees
depress10239863depress
digress938323digress
dress65319833__dress
duchess1335553duchess
duress74712063_duress
egress73310433_egress
eldress835003eldress
empress1138163empress
encases93116053encases
encores9315213encore_s
encrust947873encrust
encrusts1045283encrusts
endless839833endless
engross837123engross
entrees71813773entrees
enures63919713enure_s
enureses838113enureses
enuresis845493enuresis
excess1546053exc_ess
express1637493express
fanciers13358083fanciers
fancies124018783fancie_s
fanciest133612713fanciest
fanciless1444603fanciless
fanciness1437673fanciness
fangless1237663fangless
gangrels1094973gangrels
hances115621283hanc_e_s
handless123512063handless
handpress1544033handpress
heiress1036813heiress
huntress1144833huntress
impress1137773impress
inbreds10245733inbreds
incases93615973incases
incest82918743inc_est
incests92711383inc_ests
inchers123912523inchers
inches114419673inche_s
incises93414893incises
increase1066453increase
increases1157383increases
incrust949203incrust
incrusts1036253incrusts
incuses93514853incuses
inkless11348713inkless
innless7288293innless
inures63318953inure_s
lancers93616643lanc_ers
lances84824103lanc_e_s
lancets93411163lanc_ets
lanciers10308543lanciers
landless94011173landless
langrels9106173langrels
lankness12237043lankness
laundress1042813laundress
lucres84513303lucre_s
manches143818623manche_s
manchets15269573manchets
mandrels1137313mandrels
maneless102812343maneless
manless93012933man_less
manurers1037593manurers
manures9313353manure_s
mattress1036533mattress
mayoress1344383mayoress
naches114622413nache_s
nacre75715363nacre__
nacred95212493nacre_d
nacreous1045763nacreous
nances83618643nanc_e_s
nancies93516843nancie_s
napless93110283napless
nares55544153_nare_s
nereis6315343_nereis
ness45526563_n__ess
nurses63919353_nurses
ogress7529503_ogress
oneness7512143oneness
oppress1135993oppress
pancreases1443763pancreases
paneless102611763paneless
pantdress1243353pantdress
peeress939503peeress
press75425953__press
rances84625443ranc_e_s
ranchers133311793ranchers
ranches123620113ranche_s
ranchless1444453ranchless
rankless12268233rankless
rankness12267943rankness
recess8314263rec_ess
recross989833recross
redress82511873redress
regress82711453regress
repress92712683repress
sandless93212343sandless
saneness82313723saneness
screes85023963_screes
screws115513883_screws
secrets9311773secrets
seeress7311573seeress
snarers74216663snarers
snares65329033snare_s
snorers74313793snorers
snores64324313snore_s
stress66616673_stress
success1146403success
sucres84218893sucre_s
sundress936983sundress
tankless12267823tankless
tanrecs934823tan_recs
tigress836093tigress
tress55423163__tress
uncases93516553uncases
uncles8317163uncle_s
undrest8313013undrest
unfrees1048643unfrees
unless62413073un_less
unrest62918853un_rest
unrests7229463un_rests
unscrews1343313unscrews
unstress837373unstress
untruss736553untruss
victress1344523victress
votress1035483votress
waitress1135223waitress
wanness102610683wan_ness
wardress12256163wardress
zaniness1738663zaniness

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.1401276364.3
2DLD Change Limit1340272727.93616888.5
3Display Results2722720.0932924.7
 (SQL Overall)1786912728.16921874.3
 
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.