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

166 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
accosts1110799(None) 
accost101112261accost_
accents113511232accents
accepts13356352accepts
access1037672acces_s
accords1247242accords
accosted1345502accosted
accounts1285842accounts
accuses114112192accuses
across8312642acros_s
ascots85312512asco_ts
costs77231142__costs
abbots1039283abbo_ts
abioses9311493abioses
abiosis939373abiosis
aborts84916183a_borts
abvolts12104373abvolts
accedes1237713accedes
accent105116263accent_
accept123210623accept_
accesses1287493accesses
accord1178843acco_rd
accosting1446733accosting
account11109043account
accouter1245363accouter
accouters1344853accouters
accoutre1244203accoutre
accoutres1344383accoutres
accrete1137843accrete
accretes1238113accretes
accrues1135323accrues
accurst1146243accurst_
accusal11136003accusal
accusals12145053accusals
accusants1344283accusants
accuse103411033accus_e
accused12368423accused
accuser11347933accuser
accusers12285903accusers
accustom1443663accustom
accustoms1543333accustoms
acidoses1136773acidoses
acidosis1146133acidosis
acnodes1037823acnodes
acorns85013013a_corns
acquests1944643acquests
acquits1857293acquits
acrobats1258343acrobats
acrostic1239933acrostic
acrostics1346983acrostics
actors81016753acto_rs
acts66929863a_c__ts
adjusts1544503adjusts
adopts998083a_dopts
aerosats8411013aerosats
aftosas10147143aftosas
ageists848493ageists
agists75713173a_gists
airposts1045923airposts
alcoves1297873alcoves
aldoses8311203aldoses
allots64019173allo_ts
almost81014433almost_
altoists848753altoists
ancones93116343ancones
angsts738863a_ngsts
aorists74215823aorists
apposes11511473apposes
arcuses94814693arcuses
argots74116023argo_ts
ariosos7409853ariosos
arkoses113910833arkoses
arrests73312683arrests
artists74215583artists
ascents93812553ascents
asceses938623asceses
ascesis938373ascesis
ascot76522513asco_t_
assists738463assists
assorts73310153assorts
attests7278813attests
aurists74615783aurists
autists73814853autists
avocets1235453avocets
avosets1036663a_vosets
backcasts1985423backcasts
backouts1698643backouts
boosts86115013_boosts
cachets145014263cachets
cahoots1238473cahoots
casts77237793__casts
cavorts1237933cavorts
chests114916263_chests
choses115825123_choses
chotts113610983_chotts
cists76624533__cists
clasts84817293_clasts
cloots85113693_cloots
closes85425593_closes
closets94611603_closets
clots75627643_clo_ts
clouts87017203_clouts
coasts85719133_coasts
coats75634993__coats
cohosts12398803cohosts
colts76633293__colts
coopts105814583_coopts
coots75636843__coots
coses76949493__coses
cosets85824403__cosets
coss66143493__cos_s
cost68057943__cost_
costa75523733__costa
cots68054843__co_ts
crests85218703_crests
crofts114910593_crofts
cross75124503_cros_s
crusts84916543_crusts
cysts105912773__cysts
dacoits1079073dacoits
decocts1237833decocts
dicasts1078703dicasts
dicots94915793dico_ts
encysts1244313encysts
escorts9418403escorts
escots84211743esco_ts
fascists1336613fascists
frosts94214623_frosts
fucoses12148303fucoses
ghosts10489273_ghosts
glosts74513813_glosts
hosts85526703__hosts
imposts11269003imposts
incests92711383incests
lactoses1039813lactoses
locusts9277933locusts
mascots113910343masco_ts
mosts76028543__mosts
mucosas11146673mucosas
mycoses1437723mycoses
mycosis1437753mycosis
mysosts1234543mysosts
narcists1078103narcists
narcoses103910533narcoses
narcosis10388033narcosis
occults1135123occults
oocysts1243923oocysts
picots104616443pico_ts
posts75228783__posts
raccoons1265453raccoons
racists92613323racists
recasts93413533recasts
recoats92616643recoats
riposts9279403riposts
roosts64916323_roosts
sacrists1039563sacrists
schists1248543schists
scoots85315933_scoots
scots74025903_sco_ts
scouts84817943_scouts
sycoses1249133sycoses
sycosis1238803sycosis
tachists1348183tachists
upcasts11185643upcasts
utmosts934593utmosts
volosts1036563volosts

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 Limit1340271668.40615944.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911668.62520717.8
 
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.